DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on FND_FLEX_VALUES_VL

Line 3387: l_test_value fnd_flex_values_vl.flex_value%TYPE;

3383: p_rap_tbl rap_tbl_type
3384: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE) RETURN BOOLEAN IS
3385:
3386: l_return_status boolean := true;
3387: l_test_value fnd_flex_values_vl.flex_value%TYPE;
3388: i NUMBER := 0;
3389:
3390: CURSOR c_is_valid_nat_acc(
3391: p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE

Line 3396: fnd_flex_values_vl flex

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
3397: WHERE s.application_id = 101 -- GL Application ID
3398: AND s.id_flex_code = 'GL#'
3399: AND s.enabled_flag = 'Y'
3400: AND s.application_column_name = sav.application_column_name