APPS.IGS_RE_SPRVSR_LGCY_PUB dependencies on IGS_OR_UNIT

Line 198: CURSOR c_org_unit_exists (cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS

194: AND rsup.sequence_number = l_sequence_number
195: AND (rsup.end_dt IS NULL OR rsup.end_dt > p_sprvsr_dtls_rec.start_dt)
196: AND rsup.person_id = pdv.person_id;
197:
198: CURSOR c_org_unit_exists (cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS
199: SELECT 'X'
200: FROM igs_or_unit
201: WHERE org_unit_cd = cp_org_unit_cd;
202:

Line 200: FROM igs_or_unit

196: AND rsup.person_id = pdv.person_id;
197:
198: CURSOR c_org_unit_exists (cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS
199: SELECT 'X'
200: FROM igs_or_unit
201: WHERE org_unit_cd = cp_org_unit_cd;
202:
203: TYPE c_ref_cur IS REF CURSOR;
204:

Line 334: curr_stat := 'SELECT ''x'' FROM igs_or_unit WHERE org_unit_cd = :1 '||l_where_clause;

330: igs_or_gen_012_pkg.get_where_clause_api('RES_SPRVSR_LGCY', l_where_clause);
331: IF l_where_clause IS NOT NULL THEN
332: l_where_clause := CONCAT(' AND ',l_where_clause);
333:
334: curr_stat := 'SELECT ''x'' FROM igs_or_unit WHERE org_unit_cd = :1 '||l_where_clause;
335: OPEN c_org_cur FOR curr_stat USING p_sprvsr_dtls_rec.org_unit_cd,'RES_SPRVSR_LGCY';
336: FETCH c_org_cur INTO l_rec_found;
337: CLOSE c_org_cur;
338: