APPS.PAY_SA_ARCHIVE dependencies on HR_ALL_POSITIONS_F

Line 954: hr_all_positions_f hapf,

950:
951: CURSOR csr_position(p_position_id NUMBER) IS
952: select hapftl.name
953: from
954: hr_all_positions_f hapf,
955: hr_all_positions_f_tl hapftl
956: where hapf.position_id = p_position_id
957: and hapf.position_id = hapftl.position_id
958: and hapftl.language = USERENV('LANG');

Line 955: hr_all_positions_f_tl hapftl

951: CURSOR csr_position(p_position_id NUMBER) IS
952: select hapftl.name
953: from
954: hr_all_positions_f hapf,
955: hr_all_positions_f_tl hapftl
956: where hapf.position_id = p_position_id
957: and hapf.position_id = hapftl.position_id
958: and hapftl.language = USERENV('LANG');
959:

Line 1001: l_position hr_all_positions_f.name%TYPE; -- modified for bug 10255223

997: rec_employer_address csr_employer_address%ROWTYPE;
998: rec_org_address csr_organization_address%ROWTYPE;
999: l_nationality per_all_people_f.nationality%TYPE;
1000: /*l_position per_all_positions.name%TYPE; */
1001: l_position hr_all_positions_f.name%TYPE; -- modified for bug 10255223
1002: l_grade per_grades.name%TYPE;
1003: l_currency hr_organization_information.org_information10%TYPE;
1004: l_organization hr_organization_units.name%TYPE;
1005: l_pay_location hr_locations_all.address_line_1%TYPE;