DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_USER_ENTITIES

Line 147: ff_user_entities fue

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'

Line 247: ff_user_entities fue

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