APPS.PAY_CA_RL1_AMEND_MAG dependencies on FF_DATABASE_ITEMS

Line 262: FROM ff_database_items fdi,

258: i NUMBER :=0;
259:
260: cursor cur_boxo is
261: SELECT 'RZ-'||substr(fdi.user_name,23,2) code,fai.value value
262: FROM ff_database_items fdi,
263: ff_archive_items fai
264: WHERE fai.user_entity_id = fdi.user_entity_id
265: AND fai.context1 = p_arch_assact_id
266: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT____PER_JD_YTD'

Line 284: from ff_database_items fdi,

280: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_235_AMT_PER_JD_YTD','235',
281: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),1,1)||'-'||
282: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),2)) code,
283: fai.value value
284: from ff_database_items fdi,
285: ff_archive_items fai
286: where fai.user_entity_id=fdi.user_entity_id
287: and fai.context1= p_arch_assact_id
288: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'

Line 392: ff_database_items fdi1,

388:
389:
390: p_sqlstr := 'select distinct to_number(fai1.value)
391: from ff_archive_items fai1,
392: ff_database_items fdi1,
393: ff_archive_items fai2,
394: ff_database_items fdi2,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa,

Line 394: ff_database_items fdi2,

390: p_sqlstr := 'select distinct to_number(fai1.value)
391: from ff_archive_items fai1,
392: ff_database_items fdi1,
393: ff_archive_items fai2,
394: ff_database_items fdi2,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa,
397: pay_payroll_actions ppa1,
398: hr_organization_information hoi

Line 582: from ff_database_items

578: order by effective_end_date desc;
579:
580: CURSOR c_get_ue_id(cp_user_name varchar2) IS
581: select user_entity_id
582: from ff_database_items
583: where user_name = cp_user_name;
584:
585: CURSOR get_yepp_pact_id(cp_bg_id number,
586: cp_pre number,

Line 878: ff_database_items fdi

874:
875: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
876: select fai.value
877: from ff_archive_items fai,
878: ff_database_items fdi
879: where fai.user_entity_id = fdi.user_entity_id
880: and fai.context1 = b_context_id
881: and fdi.user_name = b_user_name;
882:

Line 1350: FROM ff_database_items fdi,

1346:
1347: /* added these CURSORs for bug 13360884, to get further information*/
1348: cursor cur_boxo(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is
1349: SELECT 'RZ-'||substr(fdi.user_name,23,2) code,to_number(fai.value) value
1350: FROM ff_database_items fdi,
1351: ff_archive_items fai
1352: WHERE fai.user_entity_id = fdi.user_entity_id
1353: AND fai.context1 = p_arch_assact_id
1354: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT____PER_JD_YTD'

Line 1366: from ff_database_items fdi,

1362: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_235_AMT_PER_JD_YTD','235',
1363: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),1,1)||'-'||
1364: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),2)) code,
1365: to_number(fai.value) value
1366: from ff_database_items fdi,
1367: ff_archive_items fai
1368: where fai.user_entity_id=fdi.user_entity_id
1369: and fai.context1= p_arch_assact_id
1370: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'

Line 1393: ff_database_items fdi

1389:
1390: cursor c_province( p_arch_asact_id number ) is
1391: select fai.value
1392: from ff_archive_items fai,
1393: ff_database_items fdi
1394: where fai.user_entity_id = fdi.user_entity_id
1395: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT'
1396: and fai.context1 =p_arch_asact_id;
1397:

Line 1418: ff_database_items fdi,

1414: -- date_earned
1415: fai.value -- Jurisdiction
1416: FROM
1417: ff_archive_items fai,
1418: ff_database_items fdi,
1419: per_all_people_f ppf,
1420: per_all_assignments_f paf,
1421: pay_action_interlocks pai,
1422: pay_assignment_actions paa,

Line 3463: FROM ff_database_items fdi,

3459: p_arch_assact_id,
3460: 'CAEOY_PERSON_ID'));
3461: cursor cur_boxo is
3462: SELECT 'BOXO-'||substr(fdi.user_name,23,2) DB_Name,to_number(fai.value) value
3463: FROM ff_database_items fdi,
3464: ff_archive_items fai
3465: WHERE fai.user_entity_id = fdi.user_entity_id
3466: AND fai.context1 = p_arch_assact_id
3467: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT_R__PER_JD_YTD'

Line 3486: ff_database_items fdi,

3482: union
3483: select SUBSTR(fdi.user_name,11,4)||', '||pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
3484: to_number(fai.value) value
3485: from HR_LOOKUPS HL,
3486: ff_database_items fdi,
3487: ff_archive_items fai
3488: where fai.user_entity_id=fdi.user_entity_id
3489: and fai.context1= p_arch_assactid
3490: and fdi.user_name like 'CAEOY_RL1_BOX%_AMT_PER_JD_YTD'