APPS.IGS_RE_SPRVSR_LGCY_PUB dependencies on IGS_OR_GEN_012_PKG

Line 330: igs_or_gen_012_pkg.get_where_clause_api('RES_SPRVSR_LGCY', l_where_clause);

326: -- modified the code for bug 5028599
327: IF p_sprvsr_dtls_rec.org_unit_cd IS NOT NULL THEN
328:
329: l_rec_found := NULL;
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;