APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_CARD_PROGRAMS

Line 735: l_data_feed_level_code ap_card_programs.data_feed_level_code%type;

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

Line 752: FROM ap_card_programs

748: BEGIN
749:
750: SELECT expense_clearing_ccid, nvl(data_feed_level_code,'N')
751: INTO l_expense_clearing_ccid, l_data_feed_level_code
752: FROM ap_card_programs
753: WHERE card_program_id = p_card_program_id;
754:
755: if (l_expense_clearing_ccid IS NULL) then
756: SELECT EXPENSE_CLEARING_CCID