[Home] [Help]
206: --------------------------------------------------------------------
207: update ap_expense_feed_lines efl
208: set posted_currency_code =
209: (select cp.card_program_currency_code
210: from ap_card_programs cp
211: where cp.card_program_id = efl.card_program_id)
212: where posted_currency_code is null
213: and reject_code = 'UNTESTED';
214:
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)
242: and nvl(create_distribution_flag,'N') = 'Y'
304: -- DEFAULT_ACCT_TEMPLATE on top of Employee Acct CCID (from
305: -- HR_EMPLOYEES_CURRENT_V).
306: -- o If error results from operations above, use
307: -- AP_CARD_PROFILES.EXCEPTION_CLEARING_CCID. If CCID not defined at
308: -- profile, use AP_CARD_PROGRAMS.EXCEPTION_CLEARING_CCID.
309: -- o If CCID still cannot be determined, populate REJECT_CODE to flag
310: -- as invalid account exception.
311: --
312: -- Where
390: 'I','VALIDATED',
391: 'APPROVED')),
392: efl.description
393: from ap_expense_feed_lines efl,
394: ap_card_programs cpg,
395: ap_card_profiles cpr,
396: ap_cards c,
397: hr_employees_current_v hremp,
398: IBY_FNDCPT_PAYER_ALL_INSTRS_V IBY