APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 595: FROM per_all_positions pos

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

Line 656: l_pos per_all_positions.name%TYPE;

652: l_emp_title per_all_people_f.title%TYPE;
653: l_emp_fath_title per_all_people_f.title%TYPE;
654: l_father_name per_all_people_f.full_name%TYPE;
655: l_gender per_all_people_f.sex%TYPE;
656: l_pos per_all_positions.name%TYPE;
657: l_job per_jobs.name%TYPE;
658: l_email_address per_all_people_f.email_address%TYPE;
659: l_employee_address per_addresses.address_id%TYPE;
660: l_employee_address_type per_addresses.address_type%TYPE;

Line 2477: FROM per_all_positions pos

2473:
2474: CURSOR c_pos(p_person_id NUMBER)
2475: IS
2476: SELECT nvl(pos.name,job.name) name ,job.name job
2477: FROM per_all_positions pos
2478: ,per_assignments_f asg
2479: ,per_jobs job
2480: WHERE asg.position_id=pos.position_id(+)
2481: AND asg.job_id=job.job_id(+)

Line 2570: l_position per_all_positions.name%TYPE;

2566: l_pan hr_organization_information.org_information3%TYPE;
2567: l_legal_name hr_organization_information.org_information4%TYPE;
2568: l_rep_person_id per_all_people_f.person_id%TYPE;
2569: l_rep_name per_all_people_f.full_name%TYPE;
2570: l_position per_all_positions.name%TYPE;
2571: l_job per_jobs.name%TYPE;
2572: l_rep_father per_all_people_f.full_name%TYPE;
2573: l_rep_location hr_organization_units.location_id%TYPE;
2574: l_rep_phone_no per_phones.phone_number%TYPE;