DBA Data[Home] [Help]

APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 578: l_vat_code AP_EXPENSE_REPORT_LINES_ALL.VAT_CODE%TYPE;

574: l_callingSequence varchar2(100);
575: l_org_id NUMBER;
576: l_transaction_date DATE;
577: l_employee_id NUMBER;
578: l_vat_code AP_EXPENSE_REPORT_LINES_ALL.VAT_CODE%TYPE;
579: l_amount_includes_tax_flag AP_EXPENSE_REPORT_LINES_ALL.amount_includes_tax_flag%TYPE;
580: l_parameterId number;
581:
582: BEGIN

Line 579: l_amount_includes_tax_flag AP_EXPENSE_REPORT_LINES_ALL.amount_includes_tax_flag%TYPE;

575: l_org_id NUMBER;
576: l_transaction_date DATE;
577: l_employee_id NUMBER;
578: l_vat_code AP_EXPENSE_REPORT_LINES_ALL.VAT_CODE%TYPE;
579: l_amount_includes_tax_flag AP_EXPENSE_REPORT_LINES_ALL.amount_includes_tax_flag%TYPE;
580: l_parameterId number;
581:
582: BEGIN
583: l_callingSequence := 'createCreditCardReversals';

Line 605: FROM ap_expense_report_lines_all erl,

601: nvl(cc.transaction_date,sysdate),
602: erh.employee_id,
603: erl.vat_code,
604: erl.amount_includes_tax_flag
605: FROM ap_expense_report_lines_all erl,
606: ap_credit_card_trxns_all cc,
607: ap_expense_report_headers_all erh
608: WHERE erl.report_header_id = erh.report_header_id
609: AND nvl(erl.itemization_parent_id,0) <> -1 /* Itemization Project */