APPS.IGS_EN_VAL_SUA dependencies on IGS_RE_SPRVSR

Line 108: FROM IGS_RE_SPRVSR rsup

104: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
105: CURSOR c_rsup(
106: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE) IS
107: SELECT rsup.start_dt
108: FROM IGS_RE_SPRVSR rsup
109: WHERE rsup.ca_person_id = p_person_id AND
110: rsup.ca_sequence_number = cp_ca_sequence_number AND
111: rsup.start_dt <= v_teach_end_dt AND
112: (rsup.end_dt IS NULL OR

Line 126: pl_check_dt IGS_RE_SPRVSR.start_dt%TYPE)

122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
123:
124: FUNCTION respl_check_percentage(
125: pl_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
126: pl_check_dt IGS_RE_SPRVSR.start_dt%TYPE)
127: RETURN BOOLEAN AS
128:
129: BEGIN
130: -- This is a local function to check the total percentages of

Line 138: FROM IGS_RE_SPRVSR rsup

134: vl_total_funding NUMBER;
135: CURSOR c_rsup_chk_pct IS
136: SELECT SUM(NVL(rsup.supervision_percentage, 0)),
137: SUM(NVL(rsup.funding_percentage, 0))
138: FROM IGS_RE_SPRVSR rsup
139: WHERE rsup.ca_person_id = p_person_id AND
140: rsup.ca_sequence_number = pl_ca_sequence_number AND
141: rsup.start_dt <= pl_check_dt AND
142: (rsup.end_dt IS NULL OR

Line 146: FROM IGS_RE_SPRVSR rsup

142: (rsup.end_dt IS NULL OR
143: rsup.end_dt >= pl_check_dt);
144: CURSOR c_rsup_per_type IS
145: SELECT IGS_EN_GEN_003.Get_Staff_Ind( rsup.person_id) person_type
146: FROM IGS_RE_SPRVSR rsup
147: WHERE rsup.ca_person_id = p_person_id AND
148: rsup.ca_sequence_number = pl_ca_sequence_number AND
149: rsup.start_dt <= pl_check_dt AND
150: (rsup.end_dt IS NULL OR