APPS.PAY_CA_EOY_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 1208: FROM FF_ARCHIVE_ITEMS FAI1,

1204: -- Cursor to get archived values based on Asg_act_id,jurisdiction
1205: cursor c_get_emp_t4box_data(cp_asg_act_id number,
1206: cp_jurisdiction varchar2) is
1207: SELECT fai1.context1,fdi1.user_entity_id,fai1.value
1208: FROM FF_ARCHIVE_ITEMS FAI1,
1209: ff_database_items fdi1,
1210: ff_archive_item_contexts faic,
1211: ff_contexts fc
1212: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id

Line 1225: from ff_archive_items fai

1221: -- Cursor to get archived values based on Asg_act_id
1222: cursor c_get_employee_data(cp_asg_act_id number,
1223: cp_dbi_ue_id number) is
1224: select fai.context1,fai.user_entity_id,fai.value
1225: from ff_archive_items fai
1226: where fai.user_entity_id = cp_dbi_ue_id
1227: and fai.context1 = cp_asg_act_id;
1228:
1229: i number;

Line 2028: from ff_archive_items fai

2024: cursor c_chk_payroll_action is
2025: select 'Y'
2026: from dual
2027: where exists (select null
2028: from ff_archive_items fai
2029: where fai.context1 = p_payroll_action_id
2030: and archive_type = 'PA');
2031: begin
2032:

Line 2435: from ff_archive_items fai,

2431:
2432: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2433: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
2434: select fai.value
2435: from ff_archive_items fai,
2436: ff_database_items fdi
2437: where fdi.user_entity_id = fai.user_entity_id
2438: and fai.context1 = cp_assignment_action_id
2439: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';