APPS.PAY_CA_RL1_MAG dependencies on FF_DATABASE_ITEMS

Line 89: FROM ff_database_items fdi,

85: i NUMBER :=0;
86:
87: cursor cur_boxo is
88: SELECT 'RZ-'||substr(fdi.user_name,23,2) code,fai.value value
89: FROM ff_database_items fdi,
90: ff_archive_items fai
91: WHERE fai.user_entity_id = fdi.user_entity_id
92: AND fai.context1 = p_arch_assact_id
93: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT____PER_JD_YTD'

Line 111: from ff_database_items fdi,

107: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_235_AMT_PER_JD_YTD','235',
108: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),1,1)||'-'||
109: substr(replace(substr(fdi.user_name,31),'_AMT_PER_JD_YTD',''),2)) code,
110: fai.value value
111: from ff_database_items fdi,
112: ff_archive_items fai
113: where fai.user_entity_id=fdi.user_entity_id
114: and fai.context1= p_arch_assact_id
115: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'

Line 428: ff_database_items fdi1,

424:
425:
426: p_sqlstr := 'select distinct to_number(fai1.value)
427: from ff_archive_items fai1,
428: ff_database_items fdi1,
429: ff_archive_items fai2,
430: ff_database_items fdi2,
431: pay_assignment_actions paa,
432: pay_payroll_actions ppa,

Line 430: ff_database_items fdi2,

426: p_sqlstr := 'select distinct to_number(fai1.value)
427: from ff_archive_items fai1,
428: ff_database_items fdi1,
429: ff_archive_items fai2,
430: ff_database_items fdi2,
431: pay_assignment_actions paa,
432: pay_payroll_actions ppa,
433: pay_payroll_actions ppa1,
434: hr_organization_information hoi

Line 815: ff_database_items fdi

811:
812: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
813: select fai.value
814: from ff_archive_items fai,
815: ff_database_items fdi
816: where fai.user_entity_id = fdi.user_entity_id
817: and fai.context1 = b_context_id
818: and fdi.user_name = b_user_name;
819:

Line 1253: ff_database_items fdi

1249:
1250: CURSOR c_province( p_arch_asact_id number) is
1251: select fai.value
1252: from ff_archive_items fai,
1253: ff_database_items fdi
1254: where fai.user_entity_id = fdi.user_entity_id
1255: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT'
1256: and fai.context1 =p_arch_asact_id;
1257:

Line 1425: ff_database_items fdi

1421:
1422: cursor c_province( p_arch_asact_id number ) is
1423: select fai.value
1424: from ff_archive_items fai,
1425: ff_database_items fdi
1426: where fai.user_entity_id = fdi.user_entity_id
1427: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT'
1428: and fai.context1 =p_arch_asact_id;
1429:

Line 1439: ff_database_items fdi,

1435: -- date_earned
1436: fai.value -- Jurisdiction
1437: FROM
1438: ff_archive_items fai,
1439: ff_database_items fdi,
1440: per_all_people_f ppf,
1441: per_all_assignments_f paf,
1442: pay_action_interlocks pai,
1443: pay_assignment_actions paa,

Line 4440: FROM ff_database_items fdi,

4436: p_arch_assact_id,
4437: 'CAEOY_PERSON_ID'));
4438: cursor cur_boxo is
4439: SELECT 'BOXO-'||substr(fdi.user_name,23,2) DB_Name,to_number(fai.value) value
4440: FROM ff_database_items fdi,
4441: ff_archive_items fai
4442: WHERE fai.user_entity_id = fdi.user_entity_id
4443: AND fai.context1 = p_arch_assact_id
4444: -- Modified for Bug 9135372

Line 4465: ff_database_items fdi,

4461: union
4462: select SUBSTR(fdi.user_name,11,4)||', '||pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4463: to_number(fai.value) value
4464: from HR_LOOKUPS HL,
4465: ff_database_items fdi,
4466: ff_archive_items fai
4467: where fai.user_entity_id=fdi.user_entity_id
4468: and fai.context1= p_arch_assactid
4469: and fdi.user_name like 'CAEOY_RL1_BOX%_AMT_PER_JD_YTD'