DBA Data[Home] [Help]

APPS.IGS_PR_PROUT_LGCY_PUB dependencies on IGS_OR_GEN_012_PKG

Line 865: igs_or_gen_012_pkg.get_where_clause_api (l_func_name,l_where_clause);

861: -- Organization Unit Code is NOT NULL
862: --
863: IF (p_lgcy_prout_rec.decision_org_unit_cd IS NOT NULL) THEN
864: l_func_name := 'PROG_OUTCOME_LGCY';
865: igs_or_gen_012_pkg.get_where_clause_api (l_func_name,l_where_clause);
866:
867: IF l_where_clause IS NOT NULL THEN
868: curr_stat := 'SELECT ''x'' FROM igs_or_unit WHERE org_unit_cd = :1 AND '||l_where_clause;
869: OPEN l_ref_cur FOR curr_stat USING p_lgcy_prout_rec.decision_org_unit_cd,l_func_name;