DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on PER_ALL_POSITIONS

Line 721: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;

717: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
718: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;
719: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
720: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;
721: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;
722: l_bus_group_id VARCHAR2(20);
723:
724:
725:

Line 757: FROM per_all_positions pos

753:
754: CURSOR csr_pos(p_person_id VARCHAR2)
755: IS
756: SELECT nvl(pos.name,job.name) name
757: FROM per_all_positions pos
758: ,per_assignments_f asg
759: ,per_jobs job
760: WHERE asg.position_id=pos.position_id(+)
761: AND asg.job_id=job.job_id(+)