APPS.JAI_AP_TDS_ETDS_PKG dependencies on FND_FLEX_VALUES_VL

Line 4715: from FND_FLEX_VALUES_VL a

4711: Cursor c_get_state_desc
4712: is
4713: select
4714: description
4715: from FND_FLEX_VALUES_VL a
4716: where flex_value_set_id =
4717: ( select flex_value_set_id
4718: from fnd_flex_value_sets
4719: where flex_value_set_name ='JA_IN_INDIAN_STATES'

Line 4723: lv_state_desc fnd_flex_values_vl.description%TYPE ; */ /*ETDS FVU3.1 Bug 11896260*/

4719: where flex_value_set_name ='JA_IN_INDIAN_STATES'
4720: )
4721: and flex_value = to_number(p_RespPersState) ;
4722:
4723: lv_state_desc fnd_flex_values_vl.description%TYPE ; */ /*ETDS FVU3.1 Bug 11896260*/
4724: ld_challan_start_date DATE; --added by csahoo for bug#6158875
4725: ld_challan_end_date DATE; --added by csahoo for bug#6158875
4726: /* Bug 13323753 -Start */
4727: l_RespPers_flat_no varchar2(25);

Line 5024: from FND_FLEX_VALUES_VL a

5020: Cursor c_get_state_desc
5021: is
5022: select
5023: description
5024: from FND_FLEX_VALUES_VL a
5025: where flex_value_set_id =
5026: ( select flex_value_set_id
5027: from fnd_flex_value_sets
5028: where flex_value_set_name ='JA_IN_INDIAN_STATES'

Line 5032: lv_state_desc fnd_flex_values_vl.description%TYPE ;

5028: where flex_value_set_name ='JA_IN_INDIAN_STATES'
5029: )
5030: and flex_value = to_number(p_RespPersState) ;
5031:
5032: lv_state_desc fnd_flex_values_vl.description%TYPE ;
5033: lv_request_desc VARCHAR2(200);
5034: lv_req_id NUMBER;
5035: lv_result BOOLEAN;
5036: /*ETDS FVU3.1 Bug 11896260 END*/

Line 5540: from FND_FLEX_VALUES_VL a

5536: v_state_name VARCHAR2(240) ;/*Bug 12624907 changed varchar2(2) to varchar2*/
5537: /*Bug 12624907-Start*/
5538: cursor c_get_state_code (p_state_name in varchar2) is
5539: select flex_value
5540: from FND_FLEX_VALUES_VL a
5541: where flex_value_set_id =
5542: ( select flex_value_set_id
5543: from fnd_flex_value_sets
5544: where flex_value_set_name ='JA_IN_INDIAN_STATES'