APPS.PAY_CA_EOY_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 1041: FROM FF_ARCHIVE_ITEMS FAI1,

1037: -- Cursor to get archived values based on Asg_act_id,jurisdiction
1038: cursor c_get_emp_t4box_data(cp_asg_act_id number,
1039: cp_jurisdiction varchar2) is
1040: SELECT fai1.context1,fdi1.user_entity_id,fai1.value
1041: FROM FF_ARCHIVE_ITEMS FAI1,
1042: ff_database_items fdi1,
1043: ff_archive_item_contexts faic,
1044: ff_contexts fc
1045: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id

Line 1058: from ff_archive_items fai

1054: -- Cursor to get archived values based on Asg_act_id
1055: cursor c_get_employee_data(cp_asg_act_id number,
1056: cp_dbi_ue_id number) is
1057: select fai.context1,fai.user_entity_id,fai.value
1058: from ff_archive_items fai
1059: where fai.user_entity_id = cp_dbi_ue_id
1060: and fai.context1 = cp_asg_act_id;
1061:
1062: i number;

Line 1810: from ff_archive_items fai

1806: cursor c_chk_payroll_action is
1807: select 'Y'
1808: from dual
1809: where exists (select null
1810: from ff_archive_items fai
1811: where fai.context1 = p_payroll_action_id
1812: and archive_type = 'PA');
1813: begin
1814:

Line 2146: from ff_archive_items fai,

2142:
2143: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2144: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
2145: select fai.value
2146: from ff_archive_items fai,
2147: ff_database_items fdi
2148: where fdi.user_entity_id = fai.user_entity_id
2149: and fai.context1 = cp_assignment_action_id
2150: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';