APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 594: FROM per_all_positions pos

590:
591: CURSOR c_pos
592: IS
593: SELECT nvl(pos.name,job.name) name
594: FROM per_all_positions pos
595: ,per_assignments_f asg
596: ,per_jobs job
597: WHERE asg.position_id=pos.position_id(+)
598: AND asg.job_id=job.job_id(+)

Line 655: l_pos per_all_positions.name%TYPE;

651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;
655: l_pos per_all_positions.name%TYPE;
656: l_employee_address per_addresses.address_id%TYPE;
657: l_employee_address_type per_addresses.address_type%TYPE;
658: l_phone_no per_phones.phone_number%TYPE;
659: l_phone_type per_phones.phone_type%TYPE;

Line 2411: FROM per_all_positions pos

2407:
2408: CURSOR c_pos(p_person_id NUMBER)
2409: IS
2410: SELECT nvl(pos.name,job.name) name
2411: FROM per_all_positions pos
2412: ,per_assignments_f asg
2413: ,per_jobs job
2414: WHERE asg.position_id=pos.position_id(+)
2415: AND asg.job_id=job.job_id(+)

Line 2504: l_position per_all_positions.name%TYPE;

2500: l_pan hr_organization_information.org_information3%TYPE;
2501: l_legal_name hr_organization_information.org_information4%TYPE;
2502: l_rep_person_id per_all_people_f.person_id%TYPE;
2503: l_rep_name per_all_people_f.full_name%TYPE;
2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;