APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on DUAL

Line 1533: from dual;

1529: 3, 3,
1530: 2, 2,
1531: 1, 2,
1532: 4)
1533: from dual;
1534:
1535: x_cal_type number := 0;
1536: x_count number := 0;
1537: x_stream_defined number := 0;

Line 2149: from dual;

2145: '11', 'MONTH_END_DATE ',
2146: '12', 'QUARTER_END_DATE ',
2147: '13', 'YEAR_END_DATE ',
2148: 'DAY ')
2149: from dual;
2150:
2151: /* Map the Time Level Id to the calendar type */
2152: /* If day then any calendar is fine */
2153: /* This is handled with the last case. we return column name */

Line 2170: from dual;

2166: 11, '4',
2167: 12, '4',
2168: 13, '4',
2169: 'tim.calendar_type')
2170: from dual;
2171:
2172: time_level_id number;
2173: time_level_column varchar2(100);
2174: time_cal_type varchar2(100);

Line 2712: from dual;

2708: '11', ' MONTH_END_DATE ',
2709: '12', ' QUARTER_END_DATE ',
2710: '13', ' YEAR_END_DATE ',
2711: ' DAY ')
2712: from dual;
2713:
2714: CURSOR get_meaning_1 (p_lookup_type in varchar2, p_lookup_code in varchar2) IS
2715: select meaning
2716: from fnd_lookup_values_vl

Line 3441: FROM dual

3437: BEGIN
3438:
3439: SELECT 1
3440: INTO x_price_list_data_found
3441: FROM dual
3442: WHERE EXISTS (SELECT 1
3443: FROM msd_price_list_ds_v
3444: WHERE price_list_name = c_price_list_rec.price_list_name
3445: AND ( ( nvl(start_date, X_MIN_DATE) <= l_dp_min_date

Line 3486: FROM dual

3482: BEGIN
3483:
3484: SELECT 1
3485: INTO x_price_list_data_found
3486: FROM dual
3487: WHERE EXISTS (SELECT 1
3488: FROM msd_price_list_ds_v
3489: WHERE price_list_name = c_scn_with_pls.price_list_name
3490: AND ( ( nvl(start_date, X_MIN_DATE) <= c_scn_with_pls.horizon_start_date

Line 3531: FROM dual

3527: BEGIN
3528:
3529: SELECT 1
3530: INTO x_price_list_data_found
3531: FROM dual
3532: WHERE EXISTS (SELECT 1
3533: FROM msd_price_list_ds_v
3534: WHERE price_list_name = c_param_with_pls.price_list_name
3535: AND ( ( nvl(start_date, X_MIN_DATE) <= c_param_with_pls.start_date

Line 3581: FROM dual

3577: BEGIN
3578:
3579: SELECT 1
3580: INTO x_price_list_data_found
3581: FROM dual
3582: WHERE EXISTS (SELECT 1
3583: FROM msd_price_list_v
3584: WHERE price_list_name = c_price_list_rec.price_list_name
3585: AND ( ( nvl(start_date, X_MIN_DATE) <= l_dp_min_date

Line 3626: FROM dual

3622: BEGIN
3623:
3624: SELECT 1
3625: INTO x_price_list_data_found
3626: FROM dual
3627: WHERE EXISTS (SELECT 1
3628: FROM msd_price_list_v
3629: WHERE price_list_name = c_scn_with_pls.price_list_name
3630: AND ( ( nvl(start_date, X_MIN_DATE) <= c_scn_with_pls.horizon_start_date

Line 3671: FROM dual

3667: BEGIN
3668:
3669: SELECT 1
3670: INTO x_price_list_data_found
3671: FROM dual
3672: WHERE EXISTS (SELECT 1
3673: FROM msd_price_list_v
3674: WHERE price_list_name = c_param_with_pls.price_list_name
3675: AND ( ( nvl(start_date, X_MIN_DATE) <= c_param_with_pls.start_date