APPS.PAY_CA_T4A_XML dependencies on FF_DATABASE_ITEMS

Line 107: from ff_database_items fdi,

103: cursor c_t4a_othinfo_amts_1 is
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')

Line 121: from ff_database_items fdi,

117: -- Added cursor for fix of #10312756
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')

Line 136: from ff_database_items fdi,

132:
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';

Line 537: ff_database_items fdi,

533: SUBSTR(pay_ca_t4a_reg.get_label('PAY_CA_T4A_FOOTNOTES',
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'