APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_RT_QUOTA_ASGNS

Line 2718: RETURN cn_rt_quota_asgns.rt_quota_asgn_id%TYPE

2714: p_calc_formula_id NUMBER,
2715: p_start_date DATE,
2716: p_end_date DATE
2717: )
2718: RETURN cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
2719: IS
2720: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;
2721:
2722: CURSOR get_rt_quota_asgn_id_curs

Line 2720: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;

2716: p_end_date DATE
2717: )
2718: RETURN cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
2719: IS
2720: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;
2721:
2722: CURSOR get_rt_quota_asgn_id_curs
2723: IS
2724: SELECT rt_quota_asgn_id

Line 2725: FROM cn_rt_quota_asgns

2721:
2722: CURSOR get_rt_quota_asgn_id_curs
2723: IS
2724: SELECT rt_quota_asgn_id
2725: FROM cn_rt_quota_asgns
2726: WHERE quota_id = p_quota_id
2727: AND rate_schedule_id = p_rate_schedule_id
2728: AND calc_formula_id = p_calc_formula_id
2729: AND TRUNC (start_date) = TRUNC (p_start_date)

Line 2735: FROM cn_rt_quota_asgns

2731:
2732: CURSOR get_rt_quota_asgn_id_curs1
2733: IS
2734: SELECT rt_quota_asgn_id
2735: FROM cn_rt_quota_asgns
2736: WHERE quota_id = p_quota_id
2737: AND rate_schedule_id = p_rate_schedule_id
2738: AND calc_formula_id = p_calc_formula_id
2739: AND TRUNC (start_date) = TRUNC (p_start_date)

Line 3412: FROM cn_rt_quota_asgns

3408: CURSOR prev
3409: IS
3410: SELECT start_date,
3411: end_date
3412: FROM cn_rt_quota_asgns
3413: WHERE quota_id = p_quota_id
3414: AND calc_formula_id = p_calc_formula_id
3415: AND rt_quota_asgn_id <> NVL (p_rt_quota_asgn_id, 0)
3416: AND TRUNC (start_date) < TRUNC (p_start_date)

Line 3423: FROM cn_rt_quota_asgns

3419: CURSOR NEXT
3420: IS
3421: SELECT start_date,
3422: end_date
3423: FROM cn_rt_quota_asgns
3424: WHERE quota_id = p_quota_id
3425: AND calc_formula_id = p_calc_formula_id
3426: AND rt_quota_asgn_id <> NVL (p_rt_quota_asgn_id, 0)
3427: AND TRUNC (start_date) > TRUNC (p_start_date)

Line 3905: FROM cn_rt_quota_asgns u

3901:
3902: CURSOR rate_quota_curs
3903: IS
3904: SELECT COUNT (1)
3905: FROM cn_rt_quota_asgns u
3906: WHERE u.quota_id = p_quota_id
3907: AND (u.start_date < p_start_date OR (p_end_date IS NOT NULL AND u.end_date IS NULL) OR u.end_date > p_end_date);
3908:
3909: l_record_found NUMBER;