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_ARCHIVE_ITEMS

Line 90: ff_archive_items fai

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'
94: ORDER BY substr(fdi.user_name,5,4);

Line 112: ff_archive_items fai

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'
116: union

Line 427: from ff_archive_items fai1,

423: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 20);
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,

Line 429: ff_archive_items fai2,

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,
433: pay_payroll_actions ppa1,

Line 814: from ff_archive_items fai,

810: RETURN varchar2 IS
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;

Line 871: l_context1 ff_archive_items.context1%TYPE;

867: EOL VARCHAR2(5);
868: l_address_line hr_locations.address_line_1%TYPE;
869: l_contact VARCHAR2(60);
870: l_transmitter_name VARCHAR2(100);
871: l_context1 ff_archive_items.context1%TYPE;
872: l_taxation_year VARCHAR2(4);
873: l_return VARCHAR2(60);
874: l_certification_no VARCHAR2(30);
875: l_VersionSchema VARCHAR2(20);

Line 1252: from ff_archive_items fai,

1248: EOL varchar2(10);
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;

Line 1424: from ff_archive_items fai,

1420: AND paa_arch.assignment_action_id = to_number(substr(paa.serial_number,3,14));
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;

Line 1438: ff_archive_items fai,

1434: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id),
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,

Line 4195: l_context1 ff_archive_items.context1%TYPE;

4191: lProvince NUMBER;
4192: lCodePostal NUMBER;
4193:
4194: l_taxation_year varchar2(4);
4195: l_context1 ff_archive_items.context1%TYPE;
4196: EOL varchar2(5);
4197: l_employer_name varchar2(100);
4198: l_quebec_bn varchar2(20);
4199: l_address_line hr_locations.address_line_1%TYPE;

Line 4441: ff_archive_items fai

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
4445: --AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT_R__PER_JD_YTD'

Line 4466: ff_archive_items fai

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'
4470: and fai.value <> '0'

Line 4630: l_context1 ff_archive_items.context1%TYPE;

4626: lProvince NUMBER;
4627: lCodePostal NUMBER;
4628: lLigne3 NUMBER;
4629: lCountry NUMBER;
4630: l_context1 ff_archive_items.context1%TYPE;
4631: EOL varchar2(5);
4632: l_employer_name varchar2(100);
4633: l_quebec_bn varchar2(20);
4634: