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_AMEND_MAG dependencies on FF_ARCHIVE_ITEMS

Line 263: ff_archive_items fai

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

Line 285: ff_archive_items fai

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

Line 391: from ff_archive_items fai1,

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

Line 393: ff_archive_items fai2,

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

Line 564: from ff_archive_items fai2,

560:
561: CURSOR c_get_prov_amend_flag(cp_asg_act_id number
562: ,cp_uid_rl1amend_flag number) IS
563: select fai2.value,faic.context
564: from ff_archive_items fai2,
565: ff_archive_item_contexts faic,
566: ff_contexts fc
567: where fai2.context1 = cp_asg_act_id
568: AND fai2.user_entity_id = cp_uid_rl1amend_flag

Line 877: from ff_archive_items fai,

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

Line 934: l_context1 ff_archive_items.context1%TYPE;

930: EOL VARCHAR2(5);
931: l_address_line hr_locations.address_line_1%TYPE;
932: l_contact VARCHAR2(60);
933: l_transmitter_name VARCHAR2(100);
934: l_context1 ff_archive_items.context1%TYPE;
935: l_taxation_year VARCHAR2(4);
936: l_return VARCHAR2(60);
937: l_certification_no VARCHAR2(30);
938: l_VersionSchema VARCHAR2(20);

Line 1351: ff_archive_items fai

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

Line 1367: ff_archive_items fai

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

Line 1392: from ff_archive_items fai,

1388: WHERE paa.assignment_action_id = p_assg_actid;
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;

Line 1417: ff_archive_items fai,

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

Line 3217: l_context1 ff_archive_items.context1%TYPE;

3213: lProvince NUMBER;
3214: lCodePostal NUMBER;
3215:
3216: l_taxation_year varchar2(4);
3217: l_context1 ff_archive_items.context1%TYPE;
3218: EOL varchar2(5);
3219: l_employer_name varchar2(100);
3220: l_quebec_bn varchar2(20);
3221: l_address_line hr_locations.address_line_1%TYPE;

Line 3464: ff_archive_items fai

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

Line 3487: ff_archive_items fai

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

Line 3637: l_context1 ff_archive_items.context1%TYPE;

3633: lProvince NUMBER;
3634: lCodePostal NUMBER;
3635: lLigne3 NUMBER;
3636: lCountry NUMBER;
3637: l_context1 ff_archive_items.context1%TYPE;
3638: EOL varchar2(5);
3639: l_employer_name varchar2(100);
3640: l_quebec_bn varchar2(20);
3641: