APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 10: ,position per_all_positions.name%TYPE);

6: ,pan_number per_all_people_f.per_information14%TYPE
7: ,pan_ref_number per_all_people_f.per_information14%TYPE
8: ,full_name per_all_people_f.full_name%TYPE
9: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
10: ,position per_all_positions.name%TYPE);
11:
12: TYPE t_person_data_tab_type IS TABLE OF t_person_data_rec
13: INDEX BY binary_integer;
14: --------------------------------------------------------------------------

Line 809: l_position per_all_positions.name%TYPE;

805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
807: l_rep_person_id per_all_people_f.person_id%TYPE;
808: l_rep_name per_all_people_f.full_name%TYPE;
809: l_position per_all_positions.name%TYPE;
810: l_rep_location hr_organization_units.location_id%TYPE;
811: l_rep_phone_no per_phones.phone_number%TYPE;
812: l_rep_mobile_no per_phones.phone_number%TYPE; -- Bug 12332524
813: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 1002: FROM per_all_positions pos

998:
999: CURSOR c_pos
1000: IS
1001: SELECT nvl(pos.name,job.name) name
1002: FROM per_all_positions pos
1003: ,per_assignments_f asg
1004: ,per_jobs job
1005: WHERE asg.position_id=pos.position_id(+)
1006: AND asg.job_id=job.job_id(+)

Line 1038: l_pos per_all_positions.name%TYPE;

1034: l_person_id per_all_people_f.person_id%TYPE;
1035: l_pan per_all_people_f.per_information4%TYPE;
1036: l_pan_ref_num per_all_people_f.per_information14%TYPE;
1037: l_name per_all_people_f.full_name%TYPE;
1038: l_pos per_all_positions.name%TYPE;
1039: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
1040: l_action_info_id NUMBER;
1041: l_ovn NUMBER;
1042: flag BOOLEAN;

Line 2310: FROM per_all_positions pos

2306:
2307: CURSOR c_pos
2308: IS
2309: SELECT nvl(pos.name,job.name) name
2310: FROM per_all_positions pos
2311: ,per_assignments_f asg
2312: ,per_jobs job
2313: WHERE asg.position_id=pos.position_id(+)
2314: AND asg.job_id=job.job_id(+)

Line 2380: l_pos per_all_positions.name%TYPE;

2376:
2377: l_pan per_all_people_f.per_information14%TYPE;
2378: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2379: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2380: l_pos per_all_positions.name%TYPE;
2381: l_proc VARCHAR2(100);
2382: l_message VARCHAR2(255);
2383:
2384: