| SQL Id | SQL Text |
|---|
| 09k3ak8yazq84 | SELECT S.BASE_CURRENCY_CODE, :B1 , C.NAME, NVL(S.MULTI_CURRENCY_FLAG, 'N') FROM AP_SYSTEM_PARAMETERS S, FND_CURRENCIES_VL C WHERE C.CURRENCY_CODE = S.BASE_CURRENCY_CODE |
| 0qzp60c3d1prh | SELECT PROMPT FROM AP_EXPENSE_REPORT_PARAMS WHERE PARAMETER_ID = :B1 |
| 0wmwsjy9kd92f | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 14knmm0z37a0q | declare val varchar2(256);begin :1 := fnd_session_management.GETSESSIONATTRIBUTEVALUE(:2, :3);end; |
| 1kjhvys1sd1sg | BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.OASubmitWorkflow(p_report_header_id => :1, p_preparer_id => :2, p_employee_id => :3, p_invoice_number => :4, p_reimb_curr => :5, p_cost_center => :6, p_purpose => :7, p_approver_id => :8, p_week_end_date => :9, p_workflow_appr_flag => :10, p_msg_count => :11);END; |
| 1rd31t40r4fu5 | BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END; |
| 1vk6du98mttc2 | SELECT EXPENSE_CHECK_ADDRESS_FLAG FROM FINANCIALS_SYSTEM_PARAMETERS |
| 1wr32ytknh1u9 | SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID FROM V$PROCESS P, V$SESSION S WHERE S.AUDSID = USERENV('SESSIONID') AND S.PADDR = P.ADDR |
| 2sdhb2dg1chcv | BEGIN AP_WEB_OA_MAINFLOW_PKG.GetEmployeeInfo(p_employee_id => :1, p_employee_name => :2, p_employee_num => :3, p_cost_center => :4, p_is_project_enabled => :5, p_default_reimb_currency_code => :6, p_is_cc_enabled => :7, p_max_num_segments => :8, p_userId => :9);END; |
| 3qqtuw5h6wvf0 |
SELECT * FROM (SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND AI.SOURCE in ('XpenseXpress', 'SelfService', 'CREDIT CARD', 'Both Pay') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND PV.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :1 AND P.PERSON_ID = PV.EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.C
ANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' in ('STANDARD', 'MIXED', 'PAYMENT REQUEST') AND AI.SOURCE IN ('SelfService', 'Both Pay', 'CREDIT CARD') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :2 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION ALL SELECT AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AERH.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0 =0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :3 AND PER_EMPLOYEE.PERSON_ID = AERH.EMPLOYEE_ID AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_current_approver_id = PER_APPROVER.person_id (+) AND DECODE(AERH.expense_status_code, 'PAID', ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)), 30) <= 30 AND AERH.SOURCE <> 'Both Pay' UNION SELECT AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AER
H.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0=0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :4 AND PER_EMPLOYEE.PERSON_ID = PAID_ON_BEHALF_EMPLOYEE_ID AND AERH.EMPLOYEE_ID IS NULL AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_current_approver_id = PER_APPROVER.person_id (+) AND DECODE(AERH.expense_status_code, 'PAID', ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)), 30) <= 30 AND AERH.SOURCE <> 'Both Pay' UNION ALL /* This select is for invoice imported reports by contingent workers */ SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID V
ENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND AI.SOURCE in ('XpenseXpress', 'SelfService', 'CREDIT CARD', 'Both Pay') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :5 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND AP_WEB_DB_HR_INT_PKG.IsPersonCwk(AI.PAID_ON_BEHALF_EMPLOYEE_ID)='Y' AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL)) QRSLT ORDER BY REPORT_SUBMITTED_DATE DESC |
| 3vy5h9xkfv1s5 | INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) SELECT :B1 , :B2 , WIA.NAME, WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 |
| 4ygjza9x62zmh | SELECT L.POLICY_LINE_ID FROM AP_POL_HEADERS H, AP_POL_LINES L, AP_POL_SCHEDULE_PERIODS SP, AP_SYSTEM_PARAMETERS SYS, AP_POL_EXRATE_OPTIONS RATE_OPTS, AP_EXPENSE_REPORT_PARAMS_ALL P WHERE P.PARAMETER_ID = :B4 AND H.POLICY_ID = P.COMPANY_POLICY_ID AND H.CATEGORY_CODE <> 'MILEAGE' AND H.CATEGORY_CODE <> 'PER_DIEM' AND :B1 BETWEEN H.START_DATE AND NVL(H.END_DATE, TO_DATE('31-12-4712', 'DD-MM-YYYY')) AND L.POLICY_ID = H.POLICY_ID AND L.STATUS = 'ACTIVE' AND L.SCHEDULE_PERIOD_ID = SP.SCHEDULE_PERIOD_ID AND :B1 BETWEEN SP.START_DATE AND NVL(SP.END_DATE, TO_DATE('31-12-4712', 'DD-MM-YYYY')) AND SYS.ORG_ID = RATE_OPTS.ORG_ID(+) AND (NVL(H.EMPLOYEE_ROLE_FLAG, 'N') = 'N' OR L.ROLE_ID = NVL((SELECT ROLE_ID FROM AP_POL_SCHEDULE_OPTIONS WHERE POLICY_ID = H.POLICY_ID AND OPTION_TYPE = 'EMPLOYEE_ROLE' AND STATUS = 'ACTIVE' AND (END_DATE IS NULL OR END_DATE >= :B1 ) AND ROLE_ID = DECODE(H.ROLE_CODE, 'JOB_GROUP', :B7 , 'POSITION', :B6 , 'GRADE', :B5 , -1)), -1)) AND (NVL(H.LOCATION_FLAG, 'N') = 'N' OR L.LOCATION_ID = :B3 ) AND ( (H.CATEGORY_CODE = 'AIRFARE') OR (L.CURRENCY_CODE = :B2 ) OR (NVL(H.ALLOW_RATE_CONVERSION_CODE, 'NO_CONVERSION') = 'NO_CONVERSION' AND H.CURRENCY_CODE = :B2 ) OR (H.CURRENCY_PREFERENCE = 'SRC' AND H.ALLOW_RATE_CONVERSION_CODE = 'ALLOW_CONVERSION' AND ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) OR ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , SYS.BASE_CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) AND 'Y' = GL_CURRENCY_API.RATE_EXISTS(SYS.BASE_CURRENCY_CODE, L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE))) ) OR (NVL(H.CURRENCY_PREFERENCE, 'LCR') = 'LCR' AND ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) OR ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , SYS.BASE_CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) AND 'Y' = GL_CURRENCY_API.RATE_EXISTS(SYS.BASE_CURRENCY_CODE, L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE))) ) ) AND (H.CATEGORY_CODE <> 'ACCOMMODATIONS' OR L.START_OF_SEASON IS NULL OR L.END_OF_SEASON IS NULL OR 'Y' = AP_WEB_POLICY_UTILS.ISDATEINSEASON(:B1 , L.START_OF_SEASON, L.END_OF_SEASON)) AND L.PARENT_LINE_ID IS NULL AND :B1 BETWEEN NVL(L.EFFECTIVE_START_DATE, :B1 ) AND NVL(L.EFFECTIVE_END_DATE, :B1 +1) |
| 5025fda07dapq | BEGIN PA_OTC_API.VALIDATE_OTC_DATA (p_operation => :1); END; |
| 5c8xj742thhyr | SELECT BUSINESS_GROUP_ID FROM PA_IMPLEMENTATIONS |
| 5kdm5kp8va5w0 | SELECT * FROM (SELECT AP_WEB_DB_CCARD_PKG.GetLocation(merchant_city , merchant_province_state) AS LOCATION, ApCreditCardTrxnsAll.TRX_ID, ApCreditCardTrxnsAll.CARD_PROGRAM_ID, ApCreditCardTrxnsAll.TRANSACTION_DATE, ApCreditCardTrxnsAll.TRANSACTION_AMOUNT, ApCreditCardTrxnsAll.BILLED_AMOUNT, ApCreditCardTrxnsAll.POSTED_CURRENCY_CODE, ApCreditCardTrxnsAll.BILLED_CURRENCY_CODE, ApCreditCardTrxnsAll.MERCHANT_NAME1, ApCreditCardTrxnsAll.MERCHANT_CITY, ApCreditCardTrxnsAll.MERCHANT_PROVINCE_STATE, ApCreditCardTrxnsAll.MERCHANT_COUNTRY, ApCreditCardTrxnsAll.FOLIO_TYPE, ApCreditCardTrxnsAll.CATEGORY, ApCreditCardTrxnsAll.REPORT_HEADER_ID, ApCreditCardTrxnsAll.COMPANY_PREPAID_INVOICE_ID, ApCreditCardTrxnsAll.EXPENSED_AMOUNT, CreditCardEO.CARD_ID, nvl(ApCreditCardTrxnsAll.BILLED_DATE, ApCreditCardTrxnsAll.POSTED_DATE) BILLED_DATE, ApCreditCardTrxnsAll.HOTEL_ROOM_AMOUNT, ApCreditCardTrxnsAll.HOTEL_TELEPHONE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_TAX, ApCreditCardTrxnsAll.HOTEL_BAR_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MOVIE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_GIFT_SHOP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_LAUNDRY_AMOUNT, ApCreditCardTrxnsAll.HOTEL_HEALTH_AMOUNT, ApCreditCardTrxnsAll.HOTEL_RESTAURANT_AMOUNT, ApCreditCardTrxnsAll.HOTEL_BUSINESS_AMOUNT, ApCreditCardTrxnsAll.HOTEL_PARKING_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_SERVICE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_TIP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MISC_AMOUNT, ApCreditCardTrxnsAll.PAYMENT_DUE_FROM_CODE, ApCreditCardTrxnsAll.POSTED_DATE, ApCreditCardTrxnsAll.AIR_TICKET_NUMBER, TRUNC(sysdate - NVL(POSTED_DATE, BILLED_DATE)) as Age, decode(REPORT_HEADER_ID, null, 'N', 'Y') as selected, decode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG), 'N') , decode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', decode(ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG, 'Y', 'Y', AP_WEB_CREDIT_CARD_PKG.HAS_DETAILED_TRXN(ApCreditCardTrxnsAll.trx_id) ) ), 'N') as level2or3_detail_flag, ApCreditCardTrxnsAll.DESCRIPTION FROM AP_CREDIT_CARD_TRXNS ApCreditCardTrxnsAll, AP_CARDS CreditCardEO, AP_CARD_PROGRAMS apcp WHERE ApCreditCardTrxnsAll.validate_code = 'Y' AND CreditCardEO.CARD_PROGRAM_ID = apcp.card_program_id AND ApCreditCardTrxnsAll.payment_flag <> 'Y' AND ApCreditCardTrxnsAll.billed_amount is not null AND ApCreditCardTrxnsAll.billed_currency_code = :1 AND CreditCardEO.card_id = :2 AND ApCreditCardTrxnsAll.payment_due_from_code = :3 AND ApCreditCardTrxnsAll.CARD_PROGRAM_ID = CreditCardEO.CARD_PROGRAM_ID AND ApCreditCardTrxnsAll.CARD_ID = CreditCardEO.CARD_ID AND (nvl(ApCreditCardTrxnsAll.CATEGORY, 'BUSINESS') not in ('DISPUTED', 'CREDIT', 'MATCHED', 'DEACTIVATED')) AND trunc(nvl(ApCreditCardTrxnsAll.trx_available_date, TO_DATE('01-01-1952 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))) <= trunc(sysdate)) QRSLT WHERE (report_header_id is null OR report_header_id = :4) ORDER BY age desc |
| 5y4fg1527trdk | SELECT * FROM (SELECT rsa.RULE_ASSIGNMENT_ID, rsa.RULE_SET_ID, rsa.ORG_ID, rsa.CREATION_DATE, rsa.CREATED_BY, rsa.LAST_UPDATE_LOGIN, rsa.LAST_UPDATE_DATE, rsa.LAST_UPDATED_BY, rsa.START_DATE, rsa.END_DATE, rs.rule_set_type, ou.name ORG_NAME, rs.rule_set_name, rsa.END_DATE orig_end_date FROM AP_AUD_RULE_ASSIGNMENTS_ALL rsa, AP_AUD_RULE_SETS rs, HR_ORGANIZATION_UNITS ou WHERE ou.organization_id = rsa.org_id AND rs.rule_set_id = rsa.rule_set_id AND rsa.org_id = :1 AND rs.rule_set_type = :2) QRSLT ORDER BY start_date desc |
| 6129566gyvx21 | SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2 |
| 67mmmbx5hb3p0 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END; |
| 6hr29bwvugchr | SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM GMS_IMPLEMENTATIONS WHERE ORG_ID = :B1 AND ENABLED = 'Y') |
| 6ykg6jujpwuzx | SELECT T.TASK_NUMBER FROM PA_ONLINE_TASKS_V TT, PA_TASKS T WHERE TT.TASK_ID = :B2 AND TT.PROJECT_ID = :B1 AND T.TASK_ID = TT.TASK_ID |
| 72tm9vzuscjyf | declare sess_id number; tranx_id number; new_tranx_id number; cursor c1 is select transaction_id from icx_transactions where session_id = sess_id and transaction_id = tranx_id;begin sess_id := fnd_session_utilities.XSID_to_SessionID(:1); tranx_id := :2; open c1; fetch c1 into new_tranx_id; if c1%notfound then new_tranx_id := fnd_session_management.CREATETRANSACTION(sess_id); end if; :3 := new_tranx_id;end; |
| 7hs96a541jgxn | begin fnd_session_management.updateSessionContext(p_function_id=>:1, p_application_id=>:2, p_responsibility_id=>:3, p_security_group_id=>:4, p_session_id=>:5, p_transaction_id=>:6); end; |
| 7qs7fx89194u1 | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL |
| 7r409fmf91tmv | SELECT GS.CHART_OF_ACCOUNTS_ID FROM AP_SYSTEM_PARAMETERS S, GL_SETS_OF_BOOKS GS WHERE GS.SET_OF_BOOKS_ID = S.SET_OF_BOOKS_ID AND ROWNUM = 1 |
| 7ujfmgb1j83a3 | BEGIN FND_AOLJ_UTIL.SET_NLS_CONTEXT( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13);END; |
| 7vfwgcfs452xs | SELECT P.SEGMENT1 FROM PA_ONLINE_PROJECTS_V PP, PA_PROJECTS_ALL P WHERE PP.PROJECT_ID = :B1 AND PP.PROJECT_ID = P.PROJECT_ID |
| 8y5f5jgyjry32 | select queue, avg(sysdate-ENQ_TIME) * 86400 AVERAGE_MSG_AGE from APPLSYS.AQ$WF_DEFERRED group by queue |
| 91hakq9n36htp | SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1 |
| 92u6ugfbk24qw | /* $Header: ValueSet.java 120.7.12010000.7 2009/09/01 20:55:44 hgeorgi ship $ */ select 'Y' FLEX_ENABLED_FLAG , trunc(to_date(null)) FLEX_START_DATE , trunc(to_date(null)) FLEX_END_DATE , trunc(SysDate) FLEX_SYSDATE , 'N' FLEX_SUMMARY_FLAG , NULL FLEX_COMPILED_VALUE_ATTRIBUTES , PROMPT FLEX_ID , PARAMETER_ID FLEX_DESCRIPTION from AP_EXPENSE_TYPES_V erp, AP_EXPENSE_REPORTS er where ( ((nvl(:1, 'NULL') != 'NULL' AND erp.PA_EXPENDITURE_TYPE in (select ga.EXPENDITURE_TYPE from GMS_SSA_AWARD_EXPTYPE_V ga where ga.AWARD_NUMBER = nvl(:2, -99999) )) OR nvl(:3, 'NULL') = 'NULL') AND ((erp.EXPENSE_REPORT_ID = nvl(:4, -99999)) OR (erp.WEB_ENABLED_FLAG = 'Y' AND er.WEB_ENABLED_FLAG = 'Y')) AND ( (nvl(:5, 'NULL') <> 'MILEAGE' AND nvl(:6, 'NULL') <> 'PER_DIEM' AND erp.CATEGORY_CODE <> 'MILEAGE' AND erp.CATEGORY_CODE <> 'PER_DIEM') OR (nvl(:7, 'NULL') = erp.CATEGORY_CODE) ) AND trunc(sysdate) <= trunc(nvl(er.INACTIVE_DATE, sysdate)) + nvl(:8, 0) AND trunc(sysdate) <= trunc(nvl(erp.END_DATE, sysdate)) + nvl(:9, 0) AND (nvl(:10, 'NULL') = 'NULL' OR PA_EXPENDITURE_TYPE is not NULL) AND erp.EXPENSE_REPORT_ID = er.EXPENSE_REPORT_ID) and WEB_PROMPT = :11 |
| 99p2syxffrkt0 | BEGIN hxc_timecard_utilities.get_time_periods (p_resource_id => :1 , p_resource_type => :2 , p_rec_period_start_date => :3 , p_period_type => :4 , p_duration_in_days => :5 , p_current_date => :6 , p_num_past_entries => :7 , p_num_future_entries => :8 , p_num_past_days => :9 , p_num_future_days => :10 , p_hire_date => :11 , p_show_existing_timecard => :12 , p_first_empty_period => :13 , p_periods => :14 ); END; |
| 9dq8x6239bhmt | UPDATE AP_EXP_REPORT_DISTS SET (CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, COST_CENTER) = (SELECT NVL(CODE_COMBINATION_ID, :B3 ), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, AP_WEB_DB_EXPDIST_PKG.GETCCSEGMENTVALUE(:B3 ) FROM GL_CODE_COMBINATIONS WHERE CODE_COMBINATION_ID = :B3 ) WHERE REPORT_DISTRIBUTION_ID = :B2 AND REPORT_HEADER_ID = :B1 |
| 9juw6s4yy5pzp | /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS ) |
| 9pammshaxxyx0 |
BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.validateReceiptLine(employee_id => :1, template_id => :2, summary_start_date => :3, reimbursement_currency_code => :4, reimbursement_currency_name => :5, multi_currency_flag => :6, override_approver_name => :7, number_max_flexfield => :8, start_date => :9, end_date => :10, days => :11, daily_amount => :12, receipt_amount => :13, rate => :14, amount => :15, parameter_id => :16, currency_code => :17, merchant => :18, merchantDoc => :19, taxReference => :20, taxRegNumber => :21, taxPayerId => :22, supplyCountry => :23, itemizeId => :24, cCardTrxnId => :25, group_value => :26, justification => :27, receipt_missing_flag => :28, validation_required => :29, taxOverrideFlag => :30, project_number => :31, task_number => :32, project_name => :33, task_name => :34, attribute1 => :35, attribute2 => :36, attribute3 => :37, attribute4 => :38, attribute5 => :39, attribute6 => :40, attribute7 => :41, attribute8 => :42, attribute9 => :43, attribute10 => :44, attribute11 => :45, attribute12 => :46, attribute13 => :47, attribute14 => :48, attribute15 => :49, p_IsSessionTaxEnabled => :50, p_IsSessionProjectEnabled => :51, p_calculate_amt_index => :52, p_calculated_receipt_amount => :53, p_return_status => :54, p_msg_count => :55, p_msg_data => :56, p_userId => :57, award_number => :58, p_cost_center => :59, p_template_name => :60 , p_purpose => :61 , p_override_approver_id => :62, p_last_update_date => :63 , receipt_cost_center => :64 , p_transaction_currency_type => :65, p_inverse_rate_flag => :66, p_report_header_id => :67, p_category_code => :68, p_nFreeBreakfasts1 => :69, p_nFreeBreakfasts2 => :70, p_nFreeBreakfasts3 => :71, p_nFreeLunches1 => :72, p_nFreeLunches2 => :73, p_nFreeLunches3 => :74, p_nFreeDinners1 => :75, p_nFreeDinners2 => :76, p_nFreeDinners3 => :77, p_nFreeAccommodations1 => :78, p_nFreeAccommodations2 => :79, p_nFreeAccommodations3 => :80, p_location => :81, p_dailyDistance => :82, p_tripDistance => :83, p_mileageRate => :84, p_vehicleCategory => :85, p_vehicleType => :86, p_fuelType => :87, p_numberPassengers => :88, p_default_currency_code => :89, p_default_exchange_rate_type => :90, p_header_attribute_category => :91, p_header_attribute1 => :92, p_header_attribute2 => :93, p_header_attribute3 => :94, p_header_attribute4 => :95, p_header_attribute5 => :96, p_header_attribute6 => :97, p_header_attribute7 => :98, p_header_attribute8 => :99, p_header_attribute9 => :100, p_header_attribute10 => :101, p_header_attribute11 => :102, p_header_attribute12 => :103, p_header_attribute13 => :104, p_header_attribute14 => :105, p_header_attribute15 => :106, p_receipt_index => :107, p_passenger_rate_used => :108, p_license_plate_number => :109, p_destination_from => :110, p_destination_to => :111, p_distance_unit_code => :112, p_addon_rates => :113, p_report_line_id => :114, p_itemization_parent_id => :115, p_daily_breakup_id => :116, p_start_date => :117, p_end_date => :118, p_amount => :119, p_number_of_meals => :120, p_meals_amount => :121, p_breakfast_flag => :122, p_lunch_flag => :123, p_dinner_flag => :124, p_accommodation_amount => :125, p_accommodation_flag => :126, p_hotel_name => :127, p_night_rate_type => :128, p_night_rate_amount => :129, p_pdm_rate => :130, p_rate_type_code => :131, p_pdm_breakup_dest_id => :132, p_pdm_destination_id => :133, p_dest_start_date => :134, p_dest_end_date => :135, p_location_id => :136, p_cust_meals_amount => :137, p_cust_accommodation_amount => :138,
p_cust_night_rate_amount => :139, p_cust_pdm_rate => :140, p_vat_code => :141, p_emp_attendee_count => :142, p_nonemp_attendee_count => :143);END; |
| a0b9t5ctnc47j | SELECT REPORT_DISTRIBUTION_ID FROM AP_EXP_REPORT_DISTS WHERE REPORT_HEADER_ID = :B2 AND REPORT_LINE_ID = :B1 AND ROWNUM = 1 |
| a1wfsfwd7rkcr | SELECT BASE_CURRENCY_CODE, SET_OF_BOOKS_ID, EXPENSE_REPORT_ID, DEFAULT_EXCHANGE_RATE_TYPE FROM AP_SYSTEM_PARAMETERS |
| aaw4na3kmdfkq | DECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END; |
| ar6ybm8ksq5pf | BEGIN mo_global.init(:1); END; |
| b1rpgkmtm60d1 | SELECT EXP_CYCLE_START_DAY_CODE FROM PA_IMPLEMENTATIONS |
| bnk32fdswwqrz | begin HXC_APPROVAL_WF_PKG.create_appl_period_info (:v1, :v2, :v3, :v4, :v5); end; |
| bqf04xkudk4zt | BEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END; |
| bqzutt5g7maz0 | select distinct furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id, furg.start_date, furg.end_date from fnd_user_resp_groups furg, fnd_responsibility fr where furg.user_id = :1 and furg.responsibility_id = fr.responsibility_id and furg.responsibility_application_id = fr.application_id and furg.start_date <= sysdate and (furg.end_date is null or furg.end_date >= sysdate) and fr.start_date <= sysdate and (fr.end_date is null or fr.end_date >= sysdate) order by furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id |
| brjb14n6zz752 | /* $Header: ValueSet.java 120.7.12010000.7 2009/09/01 20:55:44 hgeorgi ship $ */ select 'Y' FLEX_ENABLED_FLAG , trunc(to_date(null)) FLEX_START_DATE , trunc(to_date(null)) FLEX_END_DATE , trunc(SysDate) FLEX_SYSDATE , 'N' FLEX_SUMMARY_FLAG , NULL FLEX_COMPILED_VALUE_ATTRIBUTES , WEB_PROMPT FLEX_VALUE , PARAMETER_ID FLEX_DESCRIPTION from AP_EXPENSE_TYPES_V erp, AP_EXPENSE_REPORTS er where ( ((nvl(:1, 'NULL') != 'NULL' AND erp.PA_EXPENDITURE_TYPE in (select ga.EXPENDITURE_TYPE from GMS_SSA_AWARD_EXPTYPE_V ga where ga.AWARD_NUMBER = nvl(:2, -99999) )) OR nvl(:3, 'NULL') = 'NULL') AND ((erp.EXPENSE_REPORT_ID = nvl(:4, -99999)) OR (erp.WEB_ENABLED_FLAG = 'Y' AND er.WEB_ENABLED_FLAG = 'Y')) AND ( (nvl(:5, 'NULL') <> 'MILEAGE' AND nvl(:6, 'NULL') <> 'PER_DIEM' AND erp.CATEGORY_CODE <> 'MILEAGE' AND erp.CATEGORY_CODE <> 'PER_DIEM') OR (nvl(:7, 'NULL') = erp.CATEGORY_CODE) ) AND trunc(sysdate) <= trunc(nvl(er.INACTIVE_DATE, sysdate)) + nvl(:8, 0) AND trunc(sysdate) <= trunc(nvl(erp.END_DATE, sysdate)) + nvl(:9, 0) AND (nvl(:10, 'NULL') = 'NULL' OR PA_EXPENDITURE_TYPE is not NULL) AND erp.EXPENSE_REPORT_ID = er.EXPENSE_REPORT_ID) and PROMPT = :11 |
| chkkj84y3mv9s | BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.validateReceiptLine(employee_id => :1, template_id => :2, summary_start_date => :3, reimbursement_currency_code => :4, reimbursement_currency_name => :5, multi_currency_flag => :6, override_approver_name => :7, number_max_flexfield => :8, start_date => :9, end_date => :10, days => :11, daily_amount => :12, receipt_amount => :13, rate => :14, amount => :15, parameter_id => :16, currency_code => :17, merchant => :18, merchantDoc => :19, taxReference => :20, taxRegNumber => :21, taxPayerId => :22, supplyCountry => :23, itemizeId => :24, cCardTrxnId => :25, group_value => :26, justification => :27, receipt_missing_flag => :28, validation_required => :29, taxOverrideFlag => :30, project_number => :31, task_number => :32, project_name => :33, task_name => :34, attribute1 => :35, attribute2 => :36, attribute3 => :37, attribute4 => :38, attribute5 => :39, attribute6 => :40, attribute7 => :41, attribute8 => :42, attribute9 => :43, attribute10 => :44, attribute11 => :45, attribute12 => :46, attribute13 => :47, attribute14 => :48, attribute15 => :49, p_IsSessionTaxEnabled => :50, p_IsSessionProjectEnabled => :51, p_calculate_amt_index => :52, p_calculated_receipt_amount => :53, p_return_status => :54, p_msg_count => :55, p_msg_data => :56, p_userId => :57, award_number => :58, p_cost_center => :59, p_template_name => :60 , p_purpose => :61 , p_override_approver_id => :62, p_last_update_date => :63, receipt_cost_center => :64, p_transaction_currency_type => :65, p_inverse_rate_flag => :66, p_report_header_id => :67, p_category_code => :68, p_nFreeBreakfasts1 => :69, p_nFreeBreakfasts2 => :70, p_nFreeBreakfasts3 => :71, p_nFreeLunches1 => :72, p_nFreeLunches2 => :73, p_nFreeLunches3 => :74, p_nFreeDinners1 => :75, p_nFreeDinners2 => :76, p_nFreeDinners3 => :77, p_nFreeAccommodations1 => :78, p_nFreeAccommodations2 => :79, p_nFreeAccommodations3 => :80, p_location => :81, p_dailyDistance => :82, p_tripDistance => :83, p_mileageRate => :84, p_vehicleCategory => :85, p_vehicleType => :86, p_fuelType => :87, p_numberPassengers => :88, p_default_currency_code => :89, p_default_exchange_rate_type => :90, p_header_attribute_category => :91, p_header_attribute1 => :92, p_header_attribute2 => :93, p_header_attribute3 => :94, p_header_attribute4 => :95, p_header_attribute5 => :96, p_header_attribute6 => :97, p_header_attribute7 => :98, p_header_attribute8 => :99, p_header_attribute9 => :100, p_header_attribute10 => :101, p_header_attribute11 => :102, p_header_attribute12 => :103, p_header_attribute13 => :104, p_header_attribute14 => :105, p_header_attribute15 => :106, p_receipt_index => :107, p_passenger_rate_used => :108, p_license_plate_number => :109, p_destination_from => :110, p_destination_to => :111, p_distance_unit_code => :112, p_report_line_id => :113, p_itemization_parent_id => :114, p_cust_meals_amount => :115, p_cust_accommodation_amount => :116, p_cust_night_rate_amount => :117, p_cust_pdm_rate => :118, p_emp_attendee_count => :119, p_nonemp_attendee_count => :120 , p_vat_code => :121);END; |
| cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| cygumhvsq65t2 | begin HXC_APPROVAL_WF_PKG.is_appr_required (:v1, :v2, :v3, :v4, :v5); end; |
| dawf7hvg1ym94 | select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3 |
| dcrschgcxcbkn | begin AP_WEB_EXPENSE_WF.APVALIDATEEXPENSEREPORT (:v1, :v2, :v3, :v4, :v5); end; |
| dt2vdh82d4hrb | BEGIN :1 := FND_WEB_SEC.validate_login(:2, :3); END; |
| f2m7b1g3jk389 | INSERT INTO AP_EXP_REPORT_DISTS ( REPORT_HEADER_ID, REPORT_LINE_ID, REPORT_DISTRIBUTION_ID, SEQUENCE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, ORG_ID, AMOUNT, PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_ORGANIZATION_ID, COST_CENTER ) SELECT XL.REPORT_HEADER_ID, XL.REPORT_LINE_ID, AP_EXP_REPORT_DISTS_S.NEXTVAL, :B2 , SYSDATE, XL.LAST_UPDATED_BY, SYSDATE, XL.CREATED_BY, XL.CODE_COMBINATION_ID, GL.SEGMENT1, GL.SEGMENT2, GL.SEGMENT3, GL.SEGMENT4, GL.SEGMENT5, GL.SEGMENT6, GL.SEGMENT7, GL.SEGMENT8, GL.SEGMENT9, GL.SEGMENT10, GL.SEGMENT11, GL.SEGMENT12, GL.SEGMENT13, GL.SEGMENT14, GL.SEGMENT15, GL.SEGMENT16, GL.SEGMENT17, GL.SEGMENT18, GL.SEGMENT19, GL.SEGMENT20, GL.SEGMENT21, GL.SEGMENT22, GL.SEGMENT23, GL.SEGMENT24, GL.SEGMENT25, GL.SEGMENT26, GL.SEGMENT27, GL.SEGMENT28, GL.SEGMENT29, GL.SEGMENT30, XL.ORG_ID, XL.AMOUNT, XL.PROJECT_ID, XL.TASK_ID, XL.AWARD_ID, XL.EXPENDITURE_ORGANIZATION_ID, XH.FLEX_CONCATENATED FROM AP_EXPENSE_REPORT_LINES XL, AP_EXPENSE_REPORT_HEADERS XH, GL_CODE_COMBINATIONS GL WHERE XL.REPORT_LINE_ID = :B1 AND XL.REPORT_HEADER_ID = XH.REPORT_HEADER_ID AND GL.CODE_COMBINATION_ID(+) = XL.CODE_COMBINATION_ID |
| f7g96xjhudpzt | BEGIN HXC_TIMECARD.CREATE_TIMECARD (P_VALIDATE => :1 , P_BLOCKS => :2 , P_ATTRIBUTES => :3 , P_DEPOSIT_MODE => :4 , P_TEMPLATE => :5 , P_ITEM_TYPE => :6 , P_APPROVAL_PRC => :7 , P_LOCK_ROWID => :8 , P_TIMECARD_ID => :9 , P_TIMECARD_OVN => :10 , P_MESSAGES => :11 , P_CLA_SAVE => :12 ); END; |
| fpbjgy15dr12j | SELECT FLEX_CONCACTENATED FROM AP_EXPENSE_REPORT_PARAMS WHERE PARAMETER_ID = :B1 |
| ftru206x4f4un | SELECT GS.CHART_OF_ACCOUNTS_ID FROM AP_SYSTEM_PARAMETERS S, GL_SETS_OF_BOOKS GS WHERE GS.SET_OF_BOOKS_ID = S.SET_OF_BOOKS_ID |
| g3g74r6wnrv0h | SELECT * FROM (SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_type.data_capture_rule_id FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type, AP_POL_ITEMIZATIONS api WHERE parent_type.itemization_all_flag = 'N' AND api.parameter_id = parent_type.parameter_id AND child_type.parameter_id = api.itemization_parameter_id AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEGORY_CODE != 'MILEAGE' AND ('RO' = :1 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0)) UNION ALL SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_type.data_capture_rule_id FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type WHERE parent_type.itemization_all_flag = 'Y' -- Include Expense Type if it either belongs to the requested Template -- or if it is marked as "Viewable From All Tempaltes AND (child_type.expense_report_id = parent_type.expense_report_id OR child_type.web_enabled_flag = 'Y') AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEGORY_CODE != 'MILEAGE' AND ('RO' = :2 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0))) QRSLT WHERE PARENT_EXPENSE_TYPE_ID = :3 ORDER BY WEB_PROMPT |
| gpjv3cr5rgu7d | SELECT S.EXCHANGE_RATE_TYPE FROM AP_POL_EXRATE_OPTIONS S WHERE ENABLED = 'Y' |
| gyxy3j5qt6hq0 | SELECT * FROM (SELECT erp.PARAMETER_ID AS PARAMETER_ID, nvl(erp.WEB_FRIENDLY_PROMPT, erp.PROMPT) AS WEB_PROMPT, erp.PROMPT AS PROMPT, erp.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(erp.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(erp.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, erp.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(erp.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, erp.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, erp.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, erp.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, erp.COMPANY_POLICY_ID, erp.CATEGORY_CODE, erp.END_DATE, erp.ITEMIZATION_REQUIRED_FLAG, erp.ITEMIZATION_ALL_FLAG, erp.RECEIPT_REQUIRED_FLAG, erp.data_capture_rule_id, tax.name as tax_code, tax.tax_id, erp.CARD_REQUIRE_RECEIPT_AMOUNT, erp.NEG_RECEIPT_REQUIRED_FLAG FROM AP_EXPENSE_REPORT_PARAMS erp, AP_TAX_CODES tax where erp.vat_code = tax.name(+) and 'Y' = tax.WEB_ENABLED_FLAG(+)) QRSLT WHERE PARAMETER_ID = :1 |