APPS.PAY_GB_EOY_MAGTAPE dependencies on FF_USER_ENTITIES

Line 352: ff_user_entities fue,

348: FROM pay_gb_year_end_payrolls_v a
349: WHERE a.payroll_action_id = c_payroll_action_id
350: AND EXISTS (SELECT '1'
351: FROM pay_assignment_actions paa,
352: ff_user_entities fue,
353: ff_archive_items fai
354: WHERE paa.payroll_action_id = a.payroll_action_id
355: AND fue.user_entity_name = 'X_PAYROLL_ID'
356: AND fai.user_entity_id = fue.user_entity_id

Line 437: ff_user_entities fue1,

433: ,nvl(max(decode(fue2.user_entity_name,'X_MULTIPLE_ASG_FLAG',
434: SUBSTR(fai2.VALUE, 1,1))),' ')
435: FROM
436: ff_archive_items fai1,
437: ff_user_entities fue1,
438: ff_archive_items fai2,
439: ff_user_entities fue2,
440: pay_assignment_actions act
441: WHERE act.assignment_action_id = fai1.context1

Line 439: ff_user_entities fue2,

435: FROM
436: ff_archive_items fai1,
437: ff_user_entities fue1,
438: ff_archive_items fai2,
439: ff_user_entities fue2,
440: pay_assignment_actions act
441: WHERE act.assignment_action_id = fai1.context1
442: AND act.payroll_action_id = c_payroll_action_id
443: AND act.action_status = 'C'

Line 579: ff_user_entities fue,

575: ,c_payroll_action_id NUMBER) IS
576: SELECT 1
577: FROM ff_archive_item_contexts fac,
578: ff_archive_items fai,
579: ff_user_entities fue,
580: ff_archive_items fai2,
581: ff_user_entities fue2,
582: pay_assignment_actions paa
583: WHERE paa.payroll_action_id = c_payroll_action_id

Line 581: ff_user_entities fue2,

577: FROM ff_archive_item_contexts fac,
578: ff_archive_items fai,
579: ff_user_entities fue,
580: ff_archive_items fai2,
581: ff_user_entities fue2,
582: pay_assignment_actions paa
583: WHERE paa.payroll_action_id = c_payroll_action_id
584: AND fue.user_entity_name = 'X_NI_TOTAL_CONTRIBUTIONS'
585: AND fue.user_entity_id + decode(paa.assignment_action_id,0,0,0)