APPS.PAY_IN_PF_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 717: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;

713: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
714: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;
715: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
716: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;
717: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;
718: l_bus_group_id VARCHAR2(20);
719:
720:
721:

Line 753: FROM per_all_positions pos

749:
750: CURSOR csr_pos(p_person_id VARCHAR2)
751: IS
752: SELECT nvl(pos.name,job.name) name
753: FROM per_all_positions pos
754: ,per_assignments_f asg
755: ,per_jobs job
756: WHERE asg.position_id=pos.position_id(+)
757: AND asg.job_id=job.job_id(+)