APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_FORMULA_INPUTS

Line 2535: pe_calc_formula_id cn_formula_inputs.calc_formula_id%TYPE

2531: FROM cn_rt_quota_asgns rtq
2532: WHERE rtq.quota_id = pe_quota_id AND rtq.rate_schedule_id = pe_rate_schedule_id;
2533:
2534: CURSOR c_formula_input_csr (
2535: pe_calc_formula_id cn_formula_inputs.calc_formula_id%TYPE
2536: )
2537: IS
2538: SELECT fi.formula_input_id
2539: FROM cn_formula_inputs fi

Line 2539: FROM cn_formula_inputs fi

2535: pe_calc_formula_id cn_formula_inputs.calc_formula_id%TYPE
2536: )
2537: IS
2538: SELECT fi.formula_input_id
2539: FROM cn_formula_inputs fi
2540: WHERE fi.calc_formula_id = pe_calc_formula_id;
2541:
2542: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;
2543: l_split_flag cn_formula_inputs.split_flag%TYPE;

Line 2542: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;

2538: SELECT fi.formula_input_id
2539: FROM cn_formula_inputs fi
2540: WHERE fi.calc_formula_id = pe_calc_formula_id;
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;

Line 2543: l_split_flag cn_formula_inputs.split_flag%TYPE;

2539: FROM cn_formula_inputs fi
2540: WHERE fi.calc_formula_id = pe_calc_formula_id;
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

Line 2544: l_rate_dim_sequence cn_formula_inputs.rate_dim_sequence%TYPE;

2540: WHERE fi.calc_formula_id = pe_calc_formula_id;
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

Line 2561: FROM cn_formula_inputs

2557: rate_dim_sequence
2558: INTO l_cumulative_flag,
2559: l_split_flag,
2560: l_rate_dim_sequence
2561: FROM cn_formula_inputs
2562: WHERE formula_input_id = l_formula_input_id.formula_input_id;
2563:
2564: IF (l_cumulative_flag = 'Y') OR (l_split_flag = 'Y')
2565: THEN