DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on FND_FLEX_VALUES_VL

Line 2613: from FND_FLEX_VALUES_VL a

2609: Cursor c_get_state_desc
2610: is
2611: select
2612: description
2613: from FND_FLEX_VALUES_VL a
2614: where flex_value_set_id =
2615: ( select flex_value_set_id
2616: from fnd_flex_value_sets
2617: where flex_value_set_name ='JA_IN_INDIAN_STATES'

Line 2621: lv_state_desc fnd_flex_values_vl.description%TYPE ;

2617: where flex_value_set_name ='JA_IN_INDIAN_STATES'
2618: )
2619: and flex_value = to_number(p_RespPersState) ;
2620:
2621: lv_state_desc fnd_flex_values_vl.description%TYPE ;
2622: lv_request_desc VARCHAR2(200);
2623: lv_req_id NUMBER;
2624: lv_result BOOLEAN;
2625: /* Bug 12597773 -End*/