APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 304: ap_expense_report_headers RH

300: PV.awt_group_id
301: INTO p_ven_allow_awt_flag,
302: p_ven_awt_group_id
303: FROM ap_suppliers PV,
304: ap_expense_report_headers RH
305: WHERE RH.report_header_id = p_report_header_id
306: AND PV.employee_id = RH.employee_id;
307:
308: RETURN TRUE;

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