[Home] [Help]
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:
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;
765: l_rep_location hr_organization_units.location_id%TYPE;
766: l_rep_phone_no per_phones.phone_number%TYPE;
767: l_rep_email_id per_all_people_f.email_address%TYPE;
768: l_action_info_id NUMBER;
917:
918: CURSOR c_pos
919: IS
920: SELECT nvl(pos.name,job.name) name
921: FROM per_all_positions pos
922: ,per_assignments_f asg
923: ,per_jobs job
924: WHERE asg.position_id=pos.position_id(+)
925: AND asg.job_id=job.job_id(+)
953: l_person_id per_all_people_f.person_id%TYPE;
954: l_pan per_all_people_f.per_information4%TYPE;
955: l_pan_ref_num per_all_people_f.per_information14%TYPE;
956: l_name per_all_people_f.full_name%TYPE;
957: l_pos per_all_positions.name%TYPE;
958: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
959: l_action_info_id NUMBER;
960: l_ovn NUMBER;
961: flag BOOLEAN;
2200:
2201: CURSOR c_pos
2202: IS
2203: SELECT nvl(pos.name,job.name) name
2204: FROM per_all_positions pos
2205: ,per_assignments_f asg
2206: ,per_jobs job
2207: WHERE asg.position_id=pos.position_id(+)
2208: AND asg.job_id=job.job_id(+)
2270:
2271: l_pan per_all_people_f.per_information14%TYPE;
2272: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2273: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2274: l_pos per_all_positions.name%TYPE;
2275: l_proc VARCHAR2(100);
2276: l_message VARCHAR2(255);
2277:
2278: