APPS.PAY_GB_EOY_MAGTAPE dependencies on FF_ARCHIVE_ITEMS

Line 353: ff_archive_items fai

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

Line 436: ff_archive_items fai1,

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

Line 438: ff_archive_items fai2,

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

Line 578: ff_archive_items fai,

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

Line 580: ff_archive_items fai2,

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