DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on FND_FLEX_VALUE_SETS

Line 4718: from fnd_flex_value_sets

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'
4720: )
4721: and flex_value = to_number(p_RespPersState) ;
4722:

Line 5027: from fnd_flex_value_sets

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'
5029: )
5030: and flex_value = to_number(p_RespPersState) ;
5031:

Line 5543: from fnd_flex_value_sets

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'
5545: )
5546: and description= p_state_name;
5547: v_state_code varchar2(2);