eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL1_MAG dependencies on FF_DATABASE_ITEMS

Line 280: ff_database_items fdi1,

276:
277:
278: p_sqlstr := 'select distinct to_number(fai1.value)
279: from ff_archive_items fai1,
280: ff_database_items fdi1,
281: ff_archive_items fai2,
282: ff_database_items fdi2,
283: pay_assignment_actions paa,
284: pay_payroll_actions ppa,

Line 282: ff_database_items fdi2,

278: p_sqlstr := 'select distinct to_number(fai1.value)
279: from ff_archive_items fai1,
280: ff_database_items fdi1,
281: ff_archive_items fai2,
282: ff_database_items fdi2,
283: pay_assignment_actions paa,
284: pay_payroll_actions ppa,
285: pay_payroll_actions ppa1,
286: hr_organization_information hoi

Line 617: ff_database_items fdi

613:
614: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
615: select fai.value
616: from ff_archive_items fai,
617: ff_database_items fdi
618: where fai.user_entity_id = fdi.user_entity_id
619: and fai.context1 = b_context_id
620: and fdi.user_name = b_user_name;
621:

Line 1047: ff_database_items fdi

1043:
1044: cursor c_province( p_arch_asact_id number ) is
1045: select fai.value
1046: from ff_archive_items fai,
1047: ff_database_items fdi
1048: where fai.user_entity_id = fdi.user_entity_id
1049: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT'
1050: and fai.context1 =p_arch_asact_id;
1051:

Line 1072: ff_database_items fdi,

1068: -- date_earned
1069: fai.value -- Jurisdiction
1070: FROM
1071: ff_archive_items fai,
1072: ff_database_items fdi,
1073: per_all_people_f ppf,
1074: per_all_assignments_f paf,
1075: pay_action_interlocks pai,
1076: pay_assignment_actions paa,

Line 4403: FROM ff_database_items fdi,

4399: p_arch_assact_id,
4400: 'CAEOY_PERSON_ID'));
4401: cursor cur_boxo is
4402: SELECT 'BOXO-'||substr(fdi.user_name,23,2) DB_Name,to_number(fai.value) value
4403: FROM ff_database_items fdi,
4404: ff_archive_items fai
4405: WHERE fai.user_entity_id = fdi.user_entity_id
4406: AND fai.context1 = p_arch_assact_id
4407: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT_R__PER_JD_YTD'

Line 4426: ff_database_items fdi,

4422: union
4423: select SUBSTR(fdi.user_name,11,4)||', '||pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4424: to_number(fai.value) value
4425: from HR_LOOKUPS HL,
4426: ff_database_items fdi,
4427: ff_archive_items fai
4428: where fai.user_entity_id=fdi.user_entity_id
4429: and fai.context1= p_arch_assactid
4430: and fdi.user_name like 'CAEOY_RL1_BOX%_AMT_PER_JD_YTD'