APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_RATE_DIMENSIONS

Line 2545: l_dim_unit_code cn_rate_dimensions.dim_unit_code%TYPE;

2541:
2542: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;
2543: l_split_flag cn_formula_inputs.split_flag%TYPE;
2544: l_rate_dim_sequence cn_formula_inputs.rate_dim_sequence%TYPE;
2545: l_dim_unit_code cn_rate_dimensions.dim_unit_code%TYPE;
2546: l_quota_name cn_quotas.NAME%TYPE;
2547: BEGIN
2548: -- Initialize API return status to success
2549: FOR l_rate_schedule_id IN c_rate_schedule_csr (p_quota_id)

Line 2568: FROM cn_rate_dimensions cd,

2564: IF (l_cumulative_flag = 'Y') OR (l_split_flag = 'Y')
2565: THEN
2566: SELECT cd.dim_unit_code
2567: INTO l_dim_unit_code
2568: FROM cn_rate_dimensions cd,
2569: cn_rate_sch_dims cs
2570: WHERE cs.rate_dim_sequence = l_rate_dim_sequence
2571: AND cs.rate_schedule_id = l_rate_schedule_id.rate_schedule_id
2572: AND cd.rate_dimension_id = cs.rate_dimension_id;