APPS.PAY_CA_T4_XML dependencies on FF_ARCHIVE_ITEMS

Line 133: from ff_archive_items fai,

129:
130: cursor c_other_info_value is
131: select substr(fdi.user_name,27,2) code,
132: fai.value value
133: from ff_archive_items fai,
134: ff_database_items fdi,
135: ff_archive_item_contexts faic,
136: ff_contexts fc
137: where fai.user_entity_id = fdi.user_entity_id

Line 232: from ff_archive_items fai,

228: lv_ei_display_flag :=1;
229: hr_utility.trace('get_ei_earnings_display_flag p_aa_id :' ||p_aa_id);
230: begin
231: select count(1) into lv_ei_display_flag
232: from ff_archive_items fai,
233: ff_database_items fdi
234: where fai.context1 = p_aa_id
235: and fai.user_entity_id=fdi.user_entity_id
236: and fdi.user_name='CAEOY_PROVINCE_OF_EMPLOYMENT';