APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 690: FROM ff_archive_items fai1,

686: CURSOR c_get_emp_rl1box_data(cp_asg_act_id number) IS
687: SELECT fai1.context1,
688: fdi1.user_entity_id,
689: fai1.value
690: FROM ff_archive_items fai1,
691: ff_database_items fdi1,
692: ff_archive_item_contexts faic,
693: ff_contexts fc
694: WHERE fai1.user_entity_id = fdi1.user_entity_id

Line 707: FROM ff_archive_items fai

703: -- Cursor to get archived values based on Asg_act_id
704: CURSOR c_get_employee_data(cp_asg_act_id number,
705: cp_dbi_ue_id number) IS
706: SELECT fai.context1,fai.user_entity_id,fai.value
707: FROM ff_archive_items fai
708: WHERE fai.user_entity_id = cp_dbi_ue_id
709: AND fai.context1 = cp_asg_act_id;
710:
711: i number;

Line 2096: from ff_archive_items fai

2092: cursor c_chk_payroll_action is
2093: select 'Y'
2094: from dual
2095: where exists (select null
2096: from ff_archive_items fai
2097: where fai.context1 = p_payroll_action_id);
2098: begin
2099:
2100: hr_utility.trace('chk_gre_archive - checking g_archive_flag');

Line 2202: FROM FF_ARCHIVE_ITEMS FAI1,

2198:
2199: cursor c_get_arch_seq_num(cp_aaid varchar2,
2200: cp_jurisdiction varchar2) is
2201: SELECT fai1.value, fai1.archive_item_id, fai1.object_version_number
2202: FROM FF_ARCHIVE_ITEMS FAI1,
2203: ff_database_items fdi1,
2204: ff_archive_item_contexts faic,
2205: ff_contexts fc
2206: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id

Line 2305: update ff_archive_items set VALUE= l_final_seq_num

2301: ,p_archive_value => l_final_seq_num
2302: ,p_object_version_number => l_obj_ver
2303: ,p_some_warning => l_warning ); */
2304:
2305: update ff_archive_items set VALUE= l_final_seq_num
2306: where ARCHIVE_ITEM_ID= l_archive_item_id;
2307:
2308: end if;
2309: end if;

Line 3148: from ff_archive_items fai,

3144:
3145: /* New cursors added for Provincial YE Amendment Pre-Process Validation */
3146: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
3147: select fai.value
3148: from ff_archive_items fai,
3149: ff_database_items fdi
3150: where fdi.user_entity_id = fai.user_entity_id
3151: and fai.context1 = cp_assignment_action_id
3152: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT';

Line 4312: UPDATE ff_archive_items

4308: and l_year_end between start_date
4309: and end_date;
4310: lv_qpp_to_be_rprted := to_char(round(lv_archived_qpp_whld * 100 / ln_qpp_rate , 2));
4311: if ln_qpp_txble_arch_item_id <> 0 then
4312: UPDATE ff_archive_items
4313: SET value = lv_qpp_to_be_rprted
4314: WHERE archive_item_id = ln_qpp_txble_arch_item_id;
4315: end if;
4316: end if;