APPS.AP_CARD_VALIDATE_PKG dependencies on AP_CARD_PROGRAMS

Line 207: and NOT EXISTS (select 1 from ap_card_programs cp

203: (select c.employee_id
204: from ap_cards c
205: where c.card_id = efl.card_id)
206: where card_id is not null
207: and NOT EXISTS (select 1 from ap_card_programs cp
208: where cp.card_program_id = efl.card_program_id
209: and cp.card_type_lookup_code = 'SUPPLIER')
210: and reject_code = 'UNTESTED';
211:

Line 249: from ap_card_programs cp

245: --------------------------------------------------------------------
246: update ap_expense_feed_lines efl
247: set posted_currency_code =
248: (select cp.card_program_currency_code
249: from ap_card_programs cp
250: where cp.card_program_id = efl.card_program_id)
251: where posted_currency_code is null
252: and reject_code = 'UNTESTED';
253:

Line 277: ap_card_programs cp

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)
281: and nvl(create_distribution_flag,'N') = 'Y'

Line 326: and exists (select 1 from ap_card_programs cp

322: (select 1
323: from hr_employees_current_v hremp
324: where efl.employee_id = hremp.employee_id
325: )
326: and exists (select 1 from ap_card_programs cp
327: where cp.card_program_id = efl.card_program_id
328: and cp.card_type_lookup_code = 'SUPPLIER')
329: and employee_id is not null
330: and reject_code = 'UNTESTED';

Line 362: and exists (select 1 from ap_card_programs cp

358: where efl.card_program_id = cp.card_program_id
359: and nvl(cp.emp_notification_lookup_code, 'N') = 'N'
360: and nvl(cp.mgr_approval_lookup_code, 'N') = 'N'
361: )
362: and exists (select 1 from ap_card_programs cp
363: where cp.card_program_id = efl.card_program_id
364: and cp.card_type_lookup_code = 'SUPPLIER')
365: and employee_id is null
366: and reject_code = 'UNTESTED';

Line 410: -- profile, use AP_CARD_PROGRAMS.EXCEPTION_CLEARING_CCID.

406: -- DEFAULT_ACCT_TEMPLATE on top of Employee Acct CCID (from
407: -- HR_EMPLOYEES_CURRENT_V).
408: -- o If error results from operations above, use
409: -- AP_CARD_PROFILES.EXCEPTION_CLEARING_CCID. If CCID not defined at
410: -- profile, use AP_CARD_PROGRAMS.EXCEPTION_CLEARING_CCID.
411: -- o If CCID still cannot be determined, populate REJECT_CODE to flag
412: -- as invalid account exception.
413: --
414: -- Where

Line 496: ap_card_programs cpg,

492: 'I','VALIDATED',
493: 'APPROVED')),
494: efl.description
495: from ap_expense_feed_lines efl,
496: ap_card_programs cpg,
497: ap_card_profiles cpr,
498: ap_cards c,
499: hr_employees_current_v hremp,
500: IBY_FNDCPT_PAYER_ALL_INSTRS_V IBY