DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 759: l_default_emp_ccid ap_expense_report_headers_all.employee_ccid%type;

755: p_as_of_date IN DATE
756: ) RETURN BOOLEAN IS
757: -------------------------------------------------------------------------------
758: l_data_feed_level_code ap_card_programs.data_feed_level_code%type;
759: l_default_emp_ccid ap_expense_report_headers_all.employee_ccid%type;
760: l_expense_clearing_ccid ap_expense_report_headers_all.employee_ccid%type;
761: l_chart_of_accounts_id NUMBER;
762: l_num_segments NUMBER;
763: l_company_seg_num NUMBER;

Line 760: l_expense_clearing_ccid ap_expense_report_headers_all.employee_ccid%type;

756: ) RETURN BOOLEAN IS
757: -------------------------------------------------------------------------------
758: l_data_feed_level_code ap_card_programs.data_feed_level_code%type;
759: l_default_emp_ccid ap_expense_report_headers_all.employee_ccid%type;
760: l_expense_clearing_ccid ap_expense_report_headers_all.employee_ccid%type;
761: l_chart_of_accounts_id NUMBER;
762: l_num_segments NUMBER;
763: l_company_seg_num NUMBER;
764: l_flex_segment_delimiter varchar2(1);

Line 1413: l_ccid ap_expense_report_headers_all.employee_ccid%type;

1409: -------------------------------------------------------------------
1410: l_employee_id number;
1411: l_card_program_id number;
1412: l_transaction_date ap_credit_card_trxns.transaction_date%type;
1413: l_ccid ap_expense_report_headers_all.employee_ccid%type;
1414: BEGIN
1415:
1416: SELECT employee_id, txn.card_program_id, transaction_date
1417: INTO l_employee_id, l_card_program_id, l_transaction_date