141: and choi.org_information_context = 'KR_CORPORATE_INFORMATION'
142: and exists (select 'x'
143: from pay_assignment_actions xpaa,
144: pay_payroll_actions xppa,
145: ff_Archive_items fai,
146: ff_user_entities fue
147: where xppa.action_type = 'X'
148: and xppa.action_status = 'C'
149: --Bug 5069923
257: ,hr_organization_information hoi
258: ,hr_organization_information ihoi
259: ,hr_organization_units hou
260: ,ff_user_entities fue
261: ,ff_archive_items fai
262: ,ff_user_entities fue1
263: ,ff_archive_items fai1
264: WHERE xppa.action_type = 'X'
265: and xppa.action_status = 'C'
259: ,hr_organization_units hou
260: ,ff_user_entities fue
261: ,ff_archive_items fai
262: ,ff_user_entities fue1
263: ,ff_archive_items fai1
264: WHERE xppa.action_type = 'X'
265: and xppa.action_status = 'C'
266: --Bug 5069923
267: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
399: ,pay_payroll_actions xppa
400: ,hr_organization_information hoi
401: ,hr_organization_units hou
402: ,ff_user_entities fue
403: ,ff_archive_items fai
404: ,ff_user_entities fue1
405: ,ff_archive_items fai1
406: WHERE xppa.action_type = 'X'
407: and xppa.action_status = 'C'
401: ,hr_organization_units hou
402: ,ff_user_entities fue
403: ,ff_archive_items fai
404: ,ff_user_entities fue1
405: ,ff_archive_items fai1
406: WHERE xppa.action_type = 'X'
407: and xppa.action_status = 'C'
408: and xppa.effective_date
409: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))