[Home] [Help]
196: ,hr_organization_information hoi
197: ,hr_organization_information ihoi
198: ,hr_organization_units hou
199: ,ff_user_entities fue
200: ,ff_archive_items fai
201: WHERE xppa.action_type = 'X'
202: and xppa.action_status = 'C'
203: and xppa.effective_date between
204: -- Bug 4253329
233: and fai.context1= xpaa.assignment_action_id
234: -- 3627111
235: and not exists ( select 'x'
236: from ff_user_entities fue1
237: ,ff_archive_items fai1
238: where fue1.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
239: and fue1.legislation_code = 'KR'
240: and fai1.user_entity_id = fue1.user_entity_id
241: and fai1.context1 = xpaa.assignment_action_id
312: ,hr_organization_information hoi
313: ,hr_organization_information ihoi
314: ,hr_organization_units hou
315: ,ff_user_entities fue
316: ,ff_archive_items fai
317: WHERE xppa.action_type = 'X'
318: and xppa.action_status = 'C'
319: and xppa.effective_date between
320: -- Bug 4253329
353: and prt.run_type_id = paa.run_type_id -- Bug 4201616
354: -- 3627111
355: and not exists ( select 'x'
356: from ff_user_entities fue1
357: ,ff_archive_items fai1
358: where fue1.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
359: and fue1.legislation_code = 'KR'
360: and fai1.user_entity_id = fue1.user_entity_id
361: and fai1.context1 = xpaa.assignment_action_id
372: ff_contexts fc,
373: ff_user_entities fue,
374: ff_route_context_usages frc,
375: ff_archive_item_contexts fac,
376: ff_archive_items fai
377: where
378: fue.user_entity_name = 'X_KR_PREV_BP_NUMBER'
379: and fue.legislation_code = 'KR'
380: and fue.route_id = frc.route_id