APPS.PAY_GB_EOY_MAGTAPE dependencies on FF_ARCHIVE_ITEMS

Line 396: ff_archive_items fai

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
400: AND fai.context1 = paa.assignment_action_id

Line 481: ff_archive_items fai1,

477: SUBSTR(fai2.VALUE, 1,60))),' ')
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

Line 483: ff_archive_items fai2,

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
487: AND act.payroll_action_id = c_payroll_action_id

Line 638: ff_archive_items fai,

634: ,c_tax_ref_no VARCHAR2
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

Line 640: ff_archive_items fai2,

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
644: AND fue.user_entity_name = 'X_NI_TOTAL_CONTRIBUTIONS'