DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 1089: FROM ff_archive_items fai1,

1085: cursor c_get_emp_t4a_data (cp_asg_act_id number) is
1086: SELECT fai1.context1,
1087: fdi1.user_entity_id,
1088: fai1.value
1089: FROM ff_archive_items fai1,
1090: ff_database_items fdi1
1091: WHERE fai1.user_entity_id = fdi1.user_entity_id
1092: AND fai1.context1 = cp_asg_act_id
1093: AND fdi1.user_name <> 'CAEOY_T4A_AMENDMENT_FLAG'

Line 1820: from ff_archive_items fai

1816: cursor c_chk_payroll_action is
1817: select 'Y'
1818: from dual
1819: where exists (select null
1820: from ff_archive_items fai
1821: where fai.context1 = p_payroll_action_id
1822: and archive_type = 'PA');
1823: begin
1824: