APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_JOBS

Line 597: ,per_jobs job

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(+)
600: AND asg.assignment_id = p_assignment_id
601: AND asg.business_group_id = g_bg_id

Line 657: l_job per_jobs.name%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;
661: l_phone_no per_phones.phone_number%TYPE;

Line 2479: ,per_jobs job

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(+)
2482: AND asg.person_id = p_person_id
2483: AND asg.primary_flag = 'Y'

Line 2571: l_job per_jobs.name%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;
2575: l_phone_type per_phones.phone_type%TYPE;