APPS.PAY_CA_RL1_CAN_MAG dependencies on FF_DATABASE_ITEMS

Line 282: FROM ff_database_items fdi,

278: i NUMBER :=0;
279:
280: cursor cur_boxo is
281: SELECT 'RZ-'||substr(fdi.user_name,23,2) code,fai.value value
282: FROM ff_database_items fdi,
283: ff_archive_items fai
284: WHERE fai.user_entity_id = fdi.user_entity_id
285: AND fai.context1 = p_arch_assact_id
286: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT____PER_JD_YTD'

Line 304: from ff_database_items fdi,

300: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_235_AMT_PER_JD_YTD','235',
301: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),1,1)||'-'||
302: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),2)) code,
303: fai.value value
304: from ff_database_items fdi,
305: ff_archive_items fai
306: where fai.user_entity_id=fdi.user_entity_id
307: and fai.context1= p_arch_assact_id
308: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'

Line 797: ff_database_items fdi

793:
794: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
795: select fai.value
796: from ff_archive_items fai,
797: ff_database_items fdi
798: where fai.user_entity_id = fdi.user_entity_id
799: and fai.context1 = b_context_id
800: and fdi.user_name = b_user_name;
801:

Line 1293: FROM ff_database_items fdi,

1289:
1290: /* added these CURSORs for bug 13360884, to get further information*/
1291: cursor cur_boxo(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is
1292: SELECT 'RZ-'||substr(fdi.user_name,23,2) code,to_number(fai.value) value
1293: FROM ff_database_items fdi,
1294: ff_archive_items fai
1295: WHERE fai.user_entity_id = fdi.user_entity_id
1296: AND fai.context1 = p_arch_assact_id
1297: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT____PER_JD_YTD'

Line 1308: from ff_database_items fdi,

1304: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_235_AMT_PER_JD_YTD','235',
1305: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),1,1)||'-'||
1306: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),2)) code,
1307: to_number(fai.value) value
1308: from ff_database_items fdi,
1309: ff_archive_items fai
1310: where fai.user_entity_id=fdi.user_entity_id
1311: and fai.context1= p_arch_assact_id
1312: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'

Line 1325: ff_database_items fdi

1321:
1322: cursor c_province( p_arch_asact_id number ) is
1323: select fai.value
1324: from ff_archive_items fai,
1325: ff_database_items fdi
1326: where fai.user_entity_id = fdi.user_entity_id
1327: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT'
1328: and fai.context1 =p_arch_asact_id;
1329:

Line 1350: ff_database_items fdi,

1346: fai.value,
1347: get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)
1348: FROM
1349: ff_archive_items fai,
1350: ff_database_items fdi,
1351: per_all_people_f ppf,
1352: per_all_assignments_f paf,
1353: pay_action_interlocks pai_mag,
1354: pay_action_interlocks pai_arch,