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:
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(+)