APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_CARD_PROGRAMS

Line 758: l_data_feed_level_code ap_card_programs.data_feed_level_code%type;

754: p_employee_id IN NUMBER,
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;

Line 776: FROM ap_card_programs_all

772:
773: -- Bug: 11743748
774: SELECT expense_clearing_ccid, nvl(data_feed_level_code,'N')
775: INTO l_expense_clearing_ccid, l_data_feed_level_code
776: FROM ap_card_programs_all
777: WHERE card_program_id = p_card_program_id;
778:
779: if (l_expense_clearing_ccid IS NULL) then
780: SELECT EXPENSE_CLEARING_CCID