APPS.PAY_FR_ARC_PKG dependencies on PER_JOBS

Line 1593: l_ee_job_name per_jobs.name%TYPE;

1589: l_ee_soc_sec_number varchar2(30);
1590: l_ee_last_name per_all_people_f.last_name%TYPE;
1591: l_ee_first_name per_all_people_f.first_name%TYPE;
1592: l_ee_full_name per_all_people_f.full_name%TYPE;
1593: l_ee_job_name per_jobs.name%TYPE;
1594: l_ee_job_id per_jobs.job_id%type;
1595: l_ee_job_definition_id per_jobs.job_definition_id%type;
1596: l_ee_position_name per_positions.name%TYPE;
1597: l_ee_coll_agree_name per_collective_agreements.name%TYPE;

Line 1594: l_ee_job_id per_jobs.job_id%type;

1590: l_ee_last_name per_all_people_f.last_name%TYPE;
1591: l_ee_first_name per_all_people_f.first_name%TYPE;
1592: l_ee_full_name per_all_people_f.full_name%TYPE;
1593: l_ee_job_name per_jobs.name%TYPE;
1594: l_ee_job_id per_jobs.job_id%type;
1595: l_ee_job_definition_id per_jobs.job_definition_id%type;
1596: l_ee_position_name per_positions.name%TYPE;
1597: l_ee_coll_agree_name per_collective_agreements.name%TYPE;
1598: l_ee_coy_id varchar2(150);

Line 1595: l_ee_job_definition_id per_jobs.job_definition_id%type;

1591: l_ee_first_name per_all_people_f.first_name%TYPE;
1592: l_ee_full_name per_all_people_f.full_name%TYPE;
1593: l_ee_job_name per_jobs.name%TYPE;
1594: l_ee_job_id per_jobs.job_id%type;
1595: l_ee_job_definition_id per_jobs.job_definition_id%type;
1596: l_ee_position_name per_positions.name%TYPE;
1597: l_ee_coll_agree_name per_collective_agreements.name%TYPE;
1598: l_ee_coy_id varchar2(150);
1599: l_ee_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1667: ,per_jobs job

1663: ,hrl1.meaning Con_freq_mean
1664: from
1665: per_all_assignments_f asg
1666: ,per_all_people_f peo
1667: ,per_jobs job
1668: ,hr_all_positions_f_tl postl
1669: ,per_collective_agreements cag
1670: ,hr_all_organization_units est
1671: ,hr_organization_information estinfo