APPS.OKL_REPORT_PVT dependencies on OKL_REPORT_ACC_PARAMS

Line 3392: ,p_segment_id OKL_REPORT_ACC_PARAMS.SEGMENT_RANGE_FROM%TYPE) IS

3388: i NUMBER := 0;
3389:
3390: CURSOR c_is_valid_nat_acc(
3391: p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
3392: ,p_segment_id OKL_REPORT_ACC_PARAMS.SEGMENT_RANGE_FROM%TYPE) IS
3393: SELECT flex.flex_value Account_Number
3394: FROM fnd_id_flex_segments s,
3395: fnd_segment_attribute_values sav,
3396: fnd_flex_values_vl flex

Line 3546: CURSOR c_is_record_exists(p_acc_param_id OKL_REPORT_ACC_PARAMS.ACC_PARAMETER_ID%TYPE) IS

3542: p_rap_tbl IN rap_tbl_type,
3543: x_crt_rap_tbl OUT NOCOPY rap_tbl_type,
3544: x_upd_rap_tbl OUT NOCOPY rap_tbl_type) IS
3545:
3546: CURSOR c_is_record_exists(p_acc_param_id OKL_REPORT_ACC_PARAMS.ACC_PARAMETER_ID%TYPE) IS
3547: SELECT 1
3548: FROM OKL_REPORT_ACC_PARAMS
3549: WHERE ACC_PARAMETER_ID = p_acc_param_id;
3550:

Line 3548: FROM OKL_REPORT_ACC_PARAMS

3544: x_upd_rap_tbl OUT NOCOPY rap_tbl_type) IS
3545:
3546: CURSOR c_is_record_exists(p_acc_param_id OKL_REPORT_ACC_PARAMS.ACC_PARAMETER_ID%TYPE) IS
3547: SELECT 1
3548: FROM OKL_REPORT_ACC_PARAMS
3549: WHERE ACC_PARAMETER_ID = p_acc_param_id;
3550:
3551: i NUMBER := 0;
3552: crt_idx NUMBER := 0;