APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 605: FROM ff_archive_items fai1,

601: CURSOR c_get_emp_rl1box_data(cp_asg_act_id number) IS
602: SELECT fai1.context1,
603: fdi1.user_entity_id,
604: fai1.value
605: FROM ff_archive_items fai1,
606: ff_database_items fdi1,
607: ff_archive_item_contexts faic,
608: ff_contexts fc
609: WHERE fai1.user_entity_id = fdi1.user_entity_id

Line 622: FROM ff_archive_items fai

618: -- Cursor to get archived values based on Asg_act_id
619: CURSOR c_get_employee_data(cp_asg_act_id number,
620: cp_dbi_ue_id number) IS
621: SELECT fai.context1,fai.user_entity_id,fai.value
622: FROM ff_archive_items fai
623: WHERE fai.user_entity_id = cp_dbi_ue_id
624: AND fai.context1 = cp_asg_act_id;
625:
626: i number;

Line 1899: from ff_archive_items fai

1895: cursor c_chk_payroll_action is
1896: select 'Y'
1897: from dual
1898: where exists (select null
1899: from ff_archive_items fai
1900: where fai.context1 = p_payroll_action_id);
1901: begin
1902:
1903: hr_utility.trace('chk_gre_archive - checking g_archive_flag');

Line 2304: from ff_archive_items fai,

2300:
2301: /* New cursors added for Provincial YE Amendment Pre-Process Validation */
2302: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
2303: select fai.value
2304: from ff_archive_items fai,
2305: ff_database_items fdi
2306: where fdi.user_entity_id = fai.user_entity_id
2307: and fai.context1 = cp_assignment_action_id
2308: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT';