APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 325: ap_expense_report_headers RH

321: PV.awt_group_id
322: INTO p_ven_allow_awt_flag,
323: p_ven_awt_group_id
324: FROM ap_suppliers PV,
325: ap_expense_report_headers RH
326: WHERE RH.report_header_id = p_report_header_id
327: AND PV.employee_id = RH.employee_id;
328:
329: RETURN TRUE;

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