APPS.IEX_DUNNING_PUB dependencies on IEX_APP_PREFERENCES_VL

Line 495: -- FROM IEX_APP_PREFERENCES_VL

491: select aging_bucket_id from iex_dunning_plans_vl
492: where dunning_plan_id = p_dunning_plan_id;
493: -- CURSOR C_GET_BUCKET IS
494: -- SELECT preference_value
495: -- FROM IEX_APP_PREFERENCES_VL
496: --WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS AGING BUCKET';
497: -- WHERE upper(PREFERENCE_NAME) = 'DUNNING PLAN AGING BUCKET';
498: --
499: l_api_name CONSTANT VARCHAR2(30) := 'Send_Dunning';

Line 1376: FROM IEX_APP_PREFERENCES_VL

1372: P_ORG_ID IN NUMBER DEFAULT NULL) --Added for MOAC
1373: is
1374: CURSOR C_GET_LEVEL IS
1375: SELECT preference_value
1376: FROM IEX_APP_PREFERENCES_VL
1377: WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS DUNNING LEVEL';
1378: --
1379: l_api_version NUMBER := 1.0;
1380: l_msg_data VARCHAR2(4000) default NULL;

Line 1529: -- FROM IEX_APP_PREFERENCES_VL

1525: select dunning_level from iex_dunning_plans_vl
1526: where dunning_plan_id = iex_dunning_plan_id;
1527: -- 12.0 ctlee, get it from the dunning_plan
1528: -- SELECT preference_value
1529: -- FROM IEX_APP_PREFERENCES_VL
1530: -- WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS DUNNING LEVEL';
1531: --
1532: CURSOR C_GET_BUCKET (iex_dunning_plan_id number) IS
1533: select aging_bucket_id from iex_dunning_plans_vl

Line 1537: -- FROM IEX_APP_PREFERENCES_VL

1533: select aging_bucket_id from iex_dunning_plans_vl
1534: where dunning_plan_id = iex_dunning_plan_id;
1535: -- 12.0 ctlee, get it from the dunning_plan
1536: -- SELECT preference_value
1537: -- FROM IEX_APP_PREFERENCES_VL
1538: --WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS AGING BUCKET';
1539: -- WHERE upper(PREFERENCE_NAME) = 'DUNNING PLAN AGING BUCKET';
1540: --
1541: l_api_version NUMBER := 1.0;