APPS.PAY_FR_DADS_EMP_PKG dependencies on PER_JOBS

Line 1001: , per_jobs pj

997: , asg.assignment_id assignment_id -- used for fetch conventional classfication --S41.G01.00.017
998: /* DECODE(SEX, 'F', DECODE(NVL(PER_INFORMATION1, PREVIOUS_LAST_NAME), LAST_NAME, NULL,LAST_NAME) , 'M', DECODE( PREVIOUS_LAST_NAME, LAST_NAME, NULL, LAST_NAME)) Name --Getting the employee full name*/
999: From per_all_assignments_f asg
1000: ,pay_assignment_actions paa
1001: , per_jobs pj
1002: , per_all_people_f paf
1003: , per_contracts_f pc
1004: , HR_SOFT_CODING_KEYFLEX sck
1005: , hr_organization_information org_est

Line 1255: l_job_name per_jobs.name%type;

1251: l_multi_employr_code VARCHAR2(10);
1252: l_positive_offset Varchar2(10);
1253: l_job_id number;
1254: l_job_definition_id number;
1255: l_job_name per_jobs.name%type;
1256: l_pcs_code VARCHAR2(50);
1257: l_eff_job_date DATE;
1258: l_leav_reason per_periods_of_service.leaving_reason%type;
1259: