APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 912: FROM ff_archive_items fai1,

908: cursor c_get_emp_t4a_data (cp_asg_act_id number) is
909: SELECT fai1.context1,
910: fdi1.user_entity_id,
911: fai1.value
912: FROM ff_archive_items fai1,
913: ff_database_items fdi1
914: WHERE fai1.user_entity_id = fdi1.user_entity_id
915: AND fai1.context1 = cp_asg_act_id
916: AND fdi1.user_name <> 'CAEOY_T4A_AMENDMENT_FLAG'

Line 1621: from ff_archive_items fai

1617: cursor c_chk_payroll_action is
1618: select 'Y'
1619: from dual
1620: where exists (select null
1621: from ff_archive_items fai
1622: where fai.context1 = p_payroll_action_id
1623: and archive_type = 'PA');
1624: begin
1625: