APPS.IGS_EN_VAL_PIG dependencies on IGS_EN_PIG_CP_SETUP

Line 34: IS SELECT prsid_max_cp,prsid_min_cp FROM igs_en_pig_cp_setup

30: FROM igs_pe_prsid_grp_mem
31: WHERE person_id = p_person_id AND
32: TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));
33: CURSOR cur_cp (cp_group_id igs_pe_prsid_grp_mem.group_id%TYPE)
34: IS SELECT prsid_max_cp,prsid_min_cp FROM igs_en_pig_cp_setup
35: WHERE group_id = cp_group_id;
36: rec_cp cur_cp%ROWTYPE;
37: l_count NUMBER;
38: l_ret_value NUMBER DEFAULT NULL;