[Home] [Help]
143: ('TRANSFER_STATE')
144: and EXISTS (SELECT /*+ ordered */NULL
145: FROM pay_assignment_actions paa,
146: ff_archive_items fai,
147: ff_user_entities fue
148: WHERE fai.context1 = paa.assignment_action_id
149: AND paa.payroll_action_id = AA.payroll_action_id
150: AND fue.user_entity_id = fai.user_entity_id
151: AND fue.user_entity_name = 'A_SCL_ASG_US_CA_WAGE_PLAN_CODE'
243: pay_assignment_actions AA,
244: per_all_assignments_f SS,
245: per_all_people_f PE,
246: ff_archive_items fai,
247: ff_user_entities fue
248: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
249: ('TRANSFER_PAYROLL_ACTION_ID')
250: and AA.payroll_action_id = PA.payroll_action_id
251: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value