DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 736: l_default_emp_ccid ap_expense_report_headers_all.employee_ccid%type;

732: p_as_of_date IN DATE
733: ) RETURN BOOLEAN IS
734: -------------------------------------------------------------------------------
735: l_data_feed_level_code ap_card_programs.data_feed_level_code%type;
736: l_default_emp_ccid ap_expense_report_headers_all.employee_ccid%type;
737: l_expense_clearing_ccid ap_expense_report_headers_all.employee_ccid%type;
738: l_chart_of_accounts_id NUMBER;
739: l_num_segments NUMBER;
740: l_company_seg_num NUMBER;

Line 737: l_expense_clearing_ccid ap_expense_report_headers_all.employee_ccid%type;

733: ) RETURN BOOLEAN IS
734: -------------------------------------------------------------------------------
735: l_data_feed_level_code ap_card_programs.data_feed_level_code%type;
736: l_default_emp_ccid ap_expense_report_headers_all.employee_ccid%type;
737: l_expense_clearing_ccid ap_expense_report_headers_all.employee_ccid%type;
738: l_chart_of_accounts_id NUMBER;
739: l_num_segments NUMBER;
740: l_company_seg_num NUMBER;
741: l_flex_segment_delimiter varchar2(1);

Line 1371: l_ccid ap_expense_report_headers_all.employee_ccid%type;

1367: -------------------------------------------------------------------
1368: l_employee_id number;
1369: l_card_program_id number;
1370: l_transaction_date ap_credit_card_trxns.transaction_date%type;
1371: l_ccid ap_expense_report_headers_all.employee_ccid%type;
1372: BEGIN
1373:
1374: SELECT employee_id, txn.card_program_id, transaction_date
1375: INTO l_employee_id, l_card_program_id, l_transaction_date