[Home] [Help]
299: XL.mileage_rate_adjusted_flag
300: FROM ap_expense_report_params XP,
301: ap_expense_report_lines XL,
302: ap_expense_report_headers XH,
303: ap_credit_card_trxns CC,
304: ap_lookup_codes LC,
305: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
306: PA_TASKS PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
307: GMS_AWARDS GMS,
346: XL.mileage_rate_adjusted_flag
347: FROM ap_expense_report_params XP,
348: ap_expense_report_lines XL,
349: ap_expense_report_headers XH,
350: ap_credit_card_trxns CC,
351: ap_lookup_codes LC,
352: AP_POL_VIOLATIONS_V AV
353: WHERE XL.report_header_id = p_report_header_id
354: AND XL.report_header_id = XH.report_header_id
495: XL.distribution_line_number,
496: XL.MERCHANT_NAME --Bug 2942773
497: FROM ap_expense_report_params XP,
498: ap_expense_report_lines XL,
499: ap_credit_card_trxns CC,
500: ap_lookup_codes LC,
501: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
502: PA_TASKS PAT -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
503: WHERE XL.report_header_id = p_report_header_id
529: XL.distribution_line_number,
530: XL.MERCHANT_NAME --Bug 2942773
531: FROM ap_expense_report_params XP,
532: ap_expense_report_lines XL,
533: ap_credit_card_trxns CC,
534: ap_lookup_codes LC
535: WHERE XL.report_header_id = p_report_header_id
536: AND XL.web_parameter_id = XP.parameter_id
537: AND XL.line_type_lookup_code = LC.lookup_code
822: SELECT nvl(sum(erl.amount),0)
823: INTO p_personal_total
824: FROM ap_expense_report_lines erl,
825: ap_expense_report_headers aerh,
826: ap_credit_card_trxns cct
827: WHERE erl.report_header_id = p_report_header_id
828: AND aerh.report_header_id = erl.report_header_id
829: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED
830: AND nvl(erl.receipt_required_flag, 'N') = 'Y'
1157:
1158: SELECT count(*)
1159: INTO p_personal_count
1160: FROM ap_expense_report_lines XL,
1161: ap_credit_card_trxns CC
1162: WHERE XL.report_header_id = p_report_header_id
1163: AND XL.credit_card_trx_id is not null
1164: AND CC.trx_id = XL.credit_card_trx_id
1165: AND (CC.category = 'PERSONAL' OR XL.web_parameter_id = l_personalParameterId);
2499: erl.org_id,
2500: nvl(cc.transaction_date,sysdate),
2501: erh.employee_id
2502: FROM ap_expense_report_lines erl,
2503: ap_credit_card_trxns cc,
2504: ap_expense_report_headers erh
2505: WHERE erl.report_header_id = erh.report_header_id
2506: AND nvl(erl.itemization_parent_id,0) <> -1 /* Itemization Project */
2507: AND cc.trx_id = erl.credit_card_trx_id -- is a credit card transaction
2551:
2552: SELECT sum(erl.amount)
2553: INTO l_prepaid_amt
2554: FROM ap_expense_report_lines erl,
2555: ap_credit_card_trxns cc
2556: WHERE erl.report_header_id = p_expReportHeaderId
2557: AND cc.trx_id = erl.credit_card_trx_id -- is a credit card transaction
2558: AND (cc.category is null OR cc.category <> 'PERSONAL') -- not a personal expense
2559: AND erl.web_parameter_id <> l_parameterId -- Not personal itemized line
4920: LPAD(to_char(CC.expensed_amount),9),
4921: CC.billed_currency_code,
4922: nvl(CC.Merchant_name1 , Merchant_name2)
4923: FROM ap_expense_report_headers XH,
4924: ap_credit_card_trxns CC,
4925: ap_lookup_codes alc
4926: WHERE XH.report_header_id = p_report_header_id
4927: AND XH.report_header_id = CC.report_header_id
4928: AND XH.total = 0
4955:
4956: SELECT count(*)
4957: INTO p_personal_count
4958: FROM ap_expense_report_headers XH,
4959: ap_credit_card_trxns CC,
4960: ap_lookup_codes alc
4961: WHERE XH.report_header_id = p_report_header_id
4962: AND XH.report_header_id = CC.report_header_id
4963: AND XH.total = 0