APPS.AP_CARD_VALIDATE_PKG dependencies on AP_CARD_CODES

Line 11: -- o CODE_ID - FK to AP_CARD_CODES.

7: --
8: -- Populates foreign keys and validates user-provided FKs.
9: -- Determines exceptions, populates REJECT_CODE
10: -- o CARD_ID - FK to AP_CARDS. Match on CARD_NUMBER
11: -- o CODE_ID - FK to AP_CARD_CODES.
12: -- Match on CODE_VALUE for CARD_CODE_SET defined for this card program
13: -- (CARD_PROGRAM_ID)
14: -- o EMPLOYEE_ID - denormalized from AP_CARDS.
15: -- o Validates Currency Codes, CARD_PROGRAM_ID

Line 236: (select 'A corresponding card code exists in AP_CARD_CODES'

232: --------------------------------------------------------------------
233: update ap_expense_feed_lines efl
234: set reject_code = 'INVALID CARD CODE'
235: where not exists
236: (select 'A corresponding card code exists in AP_CARD_CODES'
237: from ap_card_codes cc,
238: ap_card_programs cp
239: where cc.code_value = efl.card_code_value
240: and cc.code_set_id = cp.card_code_set_id

Line 237: from ap_card_codes cc,

233: update ap_expense_feed_lines efl
234: set reject_code = 'INVALID CARD CODE'
235: where not exists
236: (select 'A corresponding card code exists in AP_CARD_CODES'
237: from ap_card_codes cc,
238: ap_card_programs cp
239: where cc.code_value = efl.card_code_value
240: and cc.code_set_id = cp.card_code_set_id
241: and cp.card_program_id = P_CARD_PROGRAM_ID)

Line 493: from ap_card_codes

489:
490: BEGIN
491: select account_segment_value
492: into l_account_segment_value
493: from ap_card_codes
494: where code_set_id = l_card_code_set_id
495: and code_value = l_card_code_value;
496: EXCEPTION
497: when NO_DATA_FOUND then