APPS.PAY_CA_RL1_MAG dependencies on FF_ARCHIVE_ITEMS

Line 279: from ff_archive_items fai1,

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

Line 281: ff_archive_items fai2,

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

Line 616: from ff_archive_items fai,

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

Line 673: l_context1 ff_archive_items.context1%TYPE;

669: EOL VARCHAR2(5);
670: l_address_line hr_locations.address_line_1%TYPE;
671: l_contact VARCHAR2(60);
672: l_transmitter_name VARCHAR2(100);
673: l_context1 ff_archive_items.context1%TYPE;
674: l_taxation_year VARCHAR2(4);
675: l_return VARCHAR2(60);
676: l_certification_no VARCHAR2(50);
677:

Line 1046: from ff_archive_items fai,

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

Line 1071: ff_archive_items fai,

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

Line 4158: l_context1 ff_archive_items.context1%TYPE;

4154: lProvince NUMBER;
4155: lCodePostal NUMBER;
4156:
4157: l_taxation_year varchar2(4);
4158: l_context1 ff_archive_items.context1%TYPE;
4159: EOL varchar2(5);
4160: l_employer_name varchar2(100);
4161: l_quebec_bn varchar2(20);
4162: l_address_line hr_locations.address_line_1%TYPE;

Line 4404: ff_archive_items fai

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

Line 4427: ff_archive_items fai

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

Line 4578: l_context1 ff_archive_items.context1%TYPE;

4574: lProvince NUMBER;
4575: lCodePostal NUMBER;
4576: lLigne3 NUMBER;
4577: lCountry NUMBER;
4578: l_context1 ff_archive_items.context1%TYPE;
4579: EOL varchar2(5);
4580: l_employer_name varchar2(100);
4581: l_quebec_bn varchar2(20);
4582: