APPS.IGS_PE_GEN_002 dependencies on IGS_PE_TYP_EMP_CAT_V

Line 887: IGS_PE_TYP_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:
890: l_emplmnt_category_code igs_pe_typ_emp_cat_v.emplmnt_category_code%TYPE;
891: BEGIN

Line 890: l_emplmnt_category_code igs_pe_typ_emp_cat_v.emplmnt_category_code%TYPE;

886: SELECT emplmnt_category_code FROM
887: IGS_PE_TYP_EMP_CAT_V
888: WHERE person_id = cp_person_id;
889:
890: l_emplmnt_category_code igs_pe_typ_emp_cat_v.emplmnt_category_code%TYPE;
891: BEGIN
892: IF IGS_PE_GEN_002.GET_HR_INSTALLED = 'Y' THEN
893: OPEN hr_emp_cat(p_person_id);
894: FETCH hr_emp_cat INTO l_emplmnt_category_code;