APPS.PAY_GB_EOY_MAGTAPE dependencies on FF_USER_ENTITIES

Line 395: ff_user_entities fue,

391: FROM pay_gb_year_end_payrolls_v a
392: WHERE a.payroll_action_id = c_payroll_action_id
393: AND EXISTS (SELECT '1'
394: FROM pay_assignment_actions paa,
395: ff_user_entities fue,
396: ff_archive_items fai
397: WHERE paa.payroll_action_id = a.payroll_action_id
398: AND fue.user_entity_name = 'X_PAYROLL_ID'
399: AND fai.user_entity_id = fue.user_entity_id

Line 482: ff_user_entities fue1,

478: ,nvl(max(decode(fue2.user_entity_name,'X_MULTIPLE_ASG_FLAG',
479: SUBSTR(fai2.VALUE, 1,1))),' ')
480: FROM
481: ff_archive_items fai1,
482: ff_user_entities fue1,
483: ff_archive_items fai2,
484: ff_user_entities fue2,
485: pay_assignment_actions act
486: WHERE act.assignment_action_id = fai1.context1

Line 484: ff_user_entities fue2,

480: FROM
481: ff_archive_items fai1,
482: ff_user_entities fue1,
483: ff_archive_items fai2,
484: ff_user_entities fue2,
485: pay_assignment_actions act
486: WHERE act.assignment_action_id = fai1.context1
487: AND act.payroll_action_id = c_payroll_action_id
488: --AND act.action_status = 'C'

Line 639: ff_user_entities fue,

635: ,c_payroll_action_id NUMBER) IS
636: SELECT 1
637: FROM ff_archive_item_contexts fac,
638: ff_archive_items fai,
639: ff_user_entities fue,
640: ff_archive_items fai2,
641: ff_user_entities fue2,
642: pay_assignment_actions paa
643: WHERE paa.payroll_action_id = c_payroll_action_id

Line 641: ff_user_entities fue2,

637: FROM ff_archive_item_contexts fac,
638: ff_archive_items fai,
639: ff_user_entities fue,
640: ff_archive_items fai2,
641: ff_user_entities fue2,
642: pay_assignment_actions paa
643: WHERE paa.payroll_action_id = c_payroll_action_id
644: AND fue.user_entity_name = 'X_NI_TOTAL_CONTRIBUTIONS'
645: AND fue.user_entity_id + decode(paa.assignment_action_id,0,0,0)