APPS.IGS_EN_VAL_PIG dependencies on IGS_EN_PIG_S_SETUP

Line 111: IS SELECT s_enrolment_step_type,notification_flag FROM igs_en_pig_s_setup

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;
115: l_notification_flag igs_en_pig_s_setup.notification_flag%TYPE;

Line 115: l_notification_flag igs_en_pig_s_setup.notification_flag%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;
115: l_notification_flag igs_en_pig_s_setup.notification_flag%TYPE;
116: l_defined_step BOOLEAN;
117: BEGIN
118: p_message := NULL;
119: --Validating the input parameters.