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 275: (select 'A corresponding card code exists in AP_CARD_CODES'

271: --------------------------------------------------------------------
272: update ap_expense_feed_lines efl
273: set reject_code = 'INVALID CARD CODE'
274: where not exists
275: (select 'A corresponding card code exists in AP_CARD_CODES'
276: from ap_card_codes cc,
277: ap_card_programs cp
278: where cc.code_value = efl.card_code_value
279: and cc.code_set_id = cp.card_code_set_id

Line 276: from ap_card_codes cc,

272: update ap_expense_feed_lines efl
273: set reject_code = 'INVALID CARD CODE'
274: where not exists
275: (select 'A corresponding card code exists in AP_CARD_CODES'
276: from ap_card_codes cc,
277: ap_card_programs cp
278: where cc.code_value = efl.card_code_value
279: and cc.code_set_id = cp.card_code_set_id
280: and cp.card_program_id = P_CARD_PROGRAM_ID)

Line 595: from ap_card_codes

591:
592: BEGIN
593: select account_segment_value
594: into l_account_segment_value
595: from ap_card_codes
596: where code_set_id = l_card_code_set_id
597: and code_value = l_card_code_value;
598: EXCEPTION
599: when NO_DATA_FOUND then