[Home] [Help]
196: ,pay_payroll_actions xppa
197: ,hr_organization_information hoi
198: ,hr_organization_information ihoi
199: ,hr_organization_units hou
200: ,ff_user_entities fue
201: ,ff_archive_items fai
202: WHERE xppa.action_type = 'X'
203: and xppa.action_status = 'C'
204: and xppa.effective_date between
233: )
234: and fai.context1= xpaa.assignment_action_id
235: -- 3627111
236: and not exists ( select 'x'
237: from ff_user_entities fue1
238: ,ff_archive_items fai1
239: where fue1.user_entity_name in ('A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN','A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN')
240: and fue1.legislation_code = 'KR'
241: and fai1.user_entity_id = fue1.user_entity_id
318: ,pay_payroll_actions xppa
319: ,hr_organization_information hoi
320: ,hr_organization_information ihoi
321: ,hr_organization_units hou
322: ,ff_user_entities fue
323: ,ff_archive_items fai
324: WHERE xppa.action_type = 'X'
325: and xppa.action_status = 'C'
326: and xppa.effective_date between
358: and fai.context1 = xpaa.assignment_action_id
359: and prt.run_type_id = paa.run_type_id -- Bug 4201616
360: -- 3627111
361: and exists ( select 'x'
362: from ff_user_entities fue2
363: ,ff_archive_items fai2
364: where fue2.user_entity_name in ('A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN','A_RECEIVABLE_SEPARATION_PAY_ASG_RUN')
365: and fue2.legislation_code = 'KR'
366: and fai2.user_entity_id = fue2.user_entity_id
366: and fai2.user_entity_id = fue2.user_entity_id
367: and fai2.context1 = xpaa.assignment_action_id
368: and fai2.value > '0' )
369: and not exists ( select 'x'
370: from ff_user_entities fue1
371: ,ff_archive_items fai1
372: where fue1.user_entity_name in ('A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN','A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN')
373: and fue1.legislation_code = 'KR'
374: and fai1.user_entity_id = fue1.user_entity_id
383: fac.context,
384: fai.value
385: from
386: ff_contexts fc,
387: ff_user_entities fue,
388: ff_route_context_usages frc,
389: ff_archive_item_contexts fac,
390: ff_archive_items fai
391: where