DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_USER_ENTITIES

Line 149: ff_user_entities fue

145: ('TRANSFER_STATE')
146: and EXISTS (SELECT /*+ ordered */NULL
147: FROM pay_assignment_actions paa,
148: ff_archive_items fai,
149: ff_user_entities fue
150: WHERE fai.context1 = paa.assignment_action_id
151: AND paa.payroll_action_id = AA.payroll_action_id
152: AND fue.user_entity_id = fai.user_entity_id
153: AND fue.user_entity_name = 'A_SCL_ASG_US_CA_WAGE_PLAN_CODE'

Line 284: ff_user_entities fue

280: pay_assignment_actions AA,
281: per_all_assignments_f SS,
282: per_all_people_f PE,
283: ff_archive_items fai,
284: ff_user_entities fue
285: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
286: ('TRANSFER_PAYROLL_ACTION_ID')
287: and AA.payroll_action_id = PA.payroll_action_id
288: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value