APPS.IGS_PE_GEN_002 dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 869: FUNCTION get_active_emp_cat(P_PERSON_ID IN IGS_PE_TYP_INSTANCES_ALL.PERSON_ID%TYPE)

865: RETURN 'N';
866: END IF;
867: END get_hr_installed;
868:
869: FUNCTION get_active_emp_cat(P_PERSON_ID IN IGS_PE_TYP_INSTANCES_ALL.PERSON_ID%TYPE)
870: RETURN VARCHAR2 IS
871: /*************************************************************
872: Created By :npalanis
873: Date Created By :10-JUN-2003

Line 880: CURSOR hr_emp_cat(cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS

876: Change History
877: Who When What
878: (reverse chronological order - newest change first)
879: ***************************************************************/
880: CURSOR hr_emp_cat(cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS
881: SELECT emplmnt_category_code FROM
882: IGS_PE_HR_EMP_CAT_V
883: WHERE person_id = cp_person_id;
884:

Line 885: CURSOR typ_emp_cat(cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS

881: SELECT emplmnt_category_code FROM
882: IGS_PE_HR_EMP_CAT_V
883: WHERE person_id = cp_person_id;
884:
885: CURSOR typ_emp_cat(cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS
886: SELECT emplmnt_category_code FROM
887: IGS_PE_TYP_EMP_CAT_V
888: WHERE person_id = cp_person_id;
889: