[Home] [Help]
135: and choi.org_information_context = 'KR_CORPORATE_INFORMATION'
136: and exists (select 'x'
137: from pay_assignment_actions xpaa,
138: pay_payroll_actions xppa,
139: ff_Archive_items fai,
140: ff_user_entities fue
141: where xppa.action_type = 'X'
142: and xppa.action_status = 'C'
143: --Bug 5069923
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: ,ff_user_entities fue1
202: ,ff_archive_items fai1
203: WHERE xppa.action_type = 'X'
204: and xppa.action_status = 'C'
198: ,hr_organization_units hou
199: ,ff_user_entities fue
200: ,ff_archive_items fai
201: ,ff_user_entities fue1
202: ,ff_archive_items fai1
203: WHERE xppa.action_type = 'X'
204: and xppa.action_status = 'C'
205: --Bug 5069923
206: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
281: ,pay_payroll_actions xppa
282: ,hr_organization_information hoi
283: ,hr_organization_units hou
284: ,ff_user_entities fue
285: ,ff_archive_items fai
286: ,ff_user_entities fue1
287: ,ff_archive_items fai1
288: WHERE xppa.action_type = 'X'
289: and xppa.action_status = 'C'
283: ,hr_organization_units hou
284: ,ff_user_entities fue
285: ,ff_archive_items fai
286: ,ff_user_entities fue1
287: ,ff_archive_items fai1
288: WHERE xppa.action_type = 'X'
289: and xppa.action_status = 'C'
290: and xppa.effective_date
291: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))
331: ff_contexts fc,
332: ff_user_entities fue,
333: ff_route_context_usages frc,
334: ff_archive_item_contexts fac,
335: ff_archive_items fai
336: where
337: fue.user_entity_name = 'X_KR_PREV_BP_NUMBER'
338: and fue.legislation_code = 'KR'
339: and fue.route_id = frc.route_id