APPS.FII_AR_UTIL_PKG dependencies on FII_AR_DSO_SETUP

Line 623: SELECT dso_value INTO l_flag FROM FII_AR_DSO_SETUP WHERE dso_type = p_category;

619: FUNCTION get_dso_setup_value(p_category IN VARCHAR2) RETURN VARCHAR2 IS
620: l_flag VARCHAR2(1) DEFAULT 'N';
621:
622: BEGIN
623: SELECT dso_value INTO l_flag FROM FII_AR_DSO_SETUP WHERE dso_type = p_category;
624: RETURN l_flag;
625:
626: END get_dso_setup_value;
627:

Line 632: l_dso_sql := ' SELECT dso_type,dso_value FROM FII_AR_DSO_SETUP ';

628:
629: PROCEDURE get_dso_table_values IS
630: l_dso_sql VARCHAR2(100);
631: BEGIN
632: l_dso_sql := ' SELECT dso_type,dso_value FROM FII_AR_DSO_SETUP ';
633: EXECUTE IMMEDIATE l_dso_sql BULK COLLECT INTO g_dso_table;
634:
635: END get_dso_table_values;
636: