eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_FORMULA_INPUTS

Line 2511: pe_calc_formula_id cn_formula_inputs.calc_formula_id%TYPE

2507: FROM cn_rt_quota_asgns rtq
2508: WHERE rtq.quota_id = pe_quota_id AND rtq.rate_schedule_id = pe_rate_schedule_id;
2509:
2510: CURSOR c_formula_input_csr (
2511: pe_calc_formula_id cn_formula_inputs.calc_formula_id%TYPE
2512: )
2513: IS
2514: SELECT fi.formula_input_id
2515: FROM cn_formula_inputs fi

Line 2515: FROM cn_formula_inputs fi

2511: pe_calc_formula_id cn_formula_inputs.calc_formula_id%TYPE
2512: )
2513: IS
2514: SELECT fi.formula_input_id
2515: FROM cn_formula_inputs fi
2516: WHERE fi.calc_formula_id = pe_calc_formula_id;
2517:
2518: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;
2519: l_split_flag cn_formula_inputs.split_flag%TYPE;

Line 2518: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;

2514: SELECT fi.formula_input_id
2515: FROM cn_formula_inputs fi
2516: WHERE fi.calc_formula_id = pe_calc_formula_id;
2517:
2518: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;
2519: l_split_flag cn_formula_inputs.split_flag%TYPE;
2520: l_rate_dim_sequence cn_formula_inputs.rate_dim_sequence%TYPE;
2521: l_dim_unit_code cn_rate_dimensions.dim_unit_code%TYPE;
2522: l_quota_name cn_quotas.NAME%TYPE;

Line 2519: l_split_flag cn_formula_inputs.split_flag%TYPE;

2515: FROM cn_formula_inputs fi
2516: WHERE fi.calc_formula_id = pe_calc_formula_id;
2517:
2518: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;
2519: l_split_flag cn_formula_inputs.split_flag%TYPE;
2520: l_rate_dim_sequence cn_formula_inputs.rate_dim_sequence%TYPE;
2521: l_dim_unit_code cn_rate_dimensions.dim_unit_code%TYPE;
2522: l_quota_name cn_quotas.NAME%TYPE;
2523: BEGIN

Line 2520: l_rate_dim_sequence cn_formula_inputs.rate_dim_sequence%TYPE;

2516: WHERE fi.calc_formula_id = pe_calc_formula_id;
2517:
2518: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;
2519: l_split_flag cn_formula_inputs.split_flag%TYPE;
2520: l_rate_dim_sequence cn_formula_inputs.rate_dim_sequence%TYPE;
2521: l_dim_unit_code cn_rate_dimensions.dim_unit_code%TYPE;
2522: l_quota_name cn_quotas.NAME%TYPE;
2523: BEGIN
2524: -- Initialize API return status to success

Line 2537: FROM cn_formula_inputs

2533: rate_dim_sequence
2534: INTO l_cumulative_flag,
2535: l_split_flag,
2536: l_rate_dim_sequence
2537: FROM cn_formula_inputs
2538: WHERE formula_input_id = l_formula_input_id.formula_input_id;
2539:
2540: IF (l_cumulative_flag = 'Y') OR (l_split_flag = 'Y')
2541: THEN