APPS.IEX_DUNNING_PUB dependencies on IEX_APP_PREFERENCES_VL

Line 1867: FROM IEX_APP_PREFERENCES_VL

1863: P_ORG_ID IN NUMBER DEFAULT NULL) --Added for MOAC
1864: is
1865: CURSOR C_GET_LEVEL IS
1866: SELECT preference_value
1867: FROM IEX_APP_PREFERENCES_VL
1868: WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS DUNNING LEVEL';
1869: --
1870: l_api_version NUMBER := 1.0;
1871: l_msg_data VARCHAR2(4000) default NULL;

Line 2037: -- FROM IEX_APP_PREFERENCES_VL

2033: select dunning_level from iex_dunning_plans_vl
2034: where dunning_plan_id = iex_dunning_plan_id;
2035: -- 12.0 ctlee, get it from the dunning_plan
2036: -- SELECT preference_value
2037: -- FROM IEX_APP_PREFERENCES_VL
2038: -- WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS DUNNING LEVEL';
2039: --
2040: CURSOR C_GET_BUCKET (iex_dunning_plan_id number) IS
2041: select aging_bucket_id from iex_dunning_plans_vl

Line 2045: -- FROM IEX_APP_PREFERENCES_VL

2041: select aging_bucket_id from iex_dunning_plans_vl
2042: where dunning_plan_id = iex_dunning_plan_id;
2043: -- 12.0 ctlee, get it from the dunning_plan
2044: -- SELECT preference_value
2045: -- FROM IEX_APP_PREFERENCES_VL
2046: --WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS AGING BUCKET';
2047: -- WHERE upper(PREFERENCE_NAME) = 'DUNNING PLAN AGING BUCKET';
2048: --
2049: l_api_version NUMBER := 1.0;