APPS.IGS_EN_VAL_PIG dependencies on IGS_PE_PRSID_GRP_MEM

Line 30: FROM igs_pe_prsid_grp_mem

26: -- the person has not been end-dated.
27: -- Bug# 3038825
28: -------------------------------------------------------------------
29: CURSOR cur_pig IS SELECT DISTINCT group_id
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

Line 33: CURSOR cur_cp (cp_group_id igs_pe_prsid_grp_mem.group_id%TYPE)

29: CURSOR cur_pig IS SELECT DISTINCT group_id
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;

Line 107: FROM igs_pe_prsid_grp_mem

103: -- the person has not been end-dated.
104: -- Bug# 3038825
105: -------------------------------------------------------------------
106: CURSOR cur_pig IS SELECT DISTINCT group_id
107: FROM igs_pe_prsid_grp_mem
108: WHERE person_id = p_person_id AND
109: TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));
110: CURSOR cur_step(p_group_id igs_pe_prsid_grp_mem.group_id%TYPE)
111: IS SELECT s_enrolment_step_type,notification_flag FROM igs_en_pig_s_setup

Line 110: CURSOR cur_step(p_group_id igs_pe_prsid_grp_mem.group_id%TYPE)

106: CURSOR cur_pig IS SELECT DISTINCT group_id
107: FROM igs_pe_prsid_grp_mem
108: WHERE person_id = p_person_id AND
109: TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));
110: CURSOR cur_step(p_group_id igs_pe_prsid_grp_mem.group_id%TYPE)
111: IS SELECT s_enrolment_step_type,notification_flag FROM igs_en_pig_s_setup
112: WHERE group_id = p_group_id;
113: l_count NUMBER:= 0;
114: l_ret_value NUMBER DEFAULT NULL;