APPS.PAY_CA_T4A_XML dependencies on FF_ARCHIVE_ITEMS

Line 108: ff_archive_items fai

104: select decode(fdi.user_name, 'CAEOY_EMPLOYEE_NUMBER', '014',
105: 'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO', '036', substr(fdi.user_name,28,3)) code,
106: fai.value value
107: from ff_database_items fdi,
108: ff_archive_items fai
109: where fai.user_entity_id=fdi.user_entity_id
110: and fai.context1= p_assignment_action_id
111: and (((fdi.user_name LIKE 'CAEOY_T4A_OTHER_INFO_AMOUNT%_PER_GRE_YTD')
112: and (fdi.user_name <> 'CAEOY_T4A_OTHER_INFO_AMOUNT036_PER_GRE_YTD')) -- #10312756

Line 122: ff_archive_items fai

118: cursor c_t4a_othinfo_amts_2 is
119: select decode(fdi.user_name, 'CAEOY_EMPLOYEE_NUMBER', '014', substr(fdi.user_name,28,3)) code,
120: fai.value value
121: from ff_database_items fdi,
122: ff_archive_items fai
123: where fai.user_entity_id=fdi.user_entity_id
124: and fai.context1= p_assignment_action_id
125: and ((fdi.user_name LIKE 'CAEOY_T4A_OTHER_INFO_AMOUNT%_PER_GRE_YTD')
126: or fdi.user_name in ('CAEOY_EMPLOYEE_NUMBER'))

Line 137: ff_archive_items fai

133: begin
134: select 'Y'
135: into l_code36_exists
136: from ff_database_items fdi,
137: ff_archive_items fai
138: where fai.user_entity_id=fdi.user_entity_id
139: and fai.context1= p_assignment_action_id
140: and fdi.user_name ='CAEOY_T4A_EMPLOYEE_REGISTRATION_NO';
141: exception

Line 538: ff_archive_items fai

534: hl.lookup_code, l_lang),1,46)) code,
535: to_number(fai.value) value
536: from hr_lookups HL,
537: ff_database_items fdi,
538: ff_archive_items fai
539: where fai.user_entity_id=fdi.user_entity_id
540: and fai.context1= p_assignment_action_id
541: and fdi.user_name like 'CAEOY_T4A_BOX%_%_AMT_PER_GRE_YTD'
542: and fai.value <> '0'