DBA Data[Home] [Help]

APPS.PAY_MX_PAYREG_PKG dependencies on FND_LOOKUP_VALUES

Line 1240: fnd_lookup_values flv

1236:
1237: CURSOR c_get_dimension_type (cp_dimension_type NUMBER) IS
1238: SELECT flv.meaning
1239: FROM fnd_lookup_types flt ,
1240: fnd_lookup_values flv
1241: WHERE flt.lookup_type = 'MX_DIMENSION'
1242: AND flt.lookup_type = flv.lookup_type
1243: AND flv.lookup_code = cp_dimension_type
1244: AND flv.enabled_flag = 'Y'

Line 1251: fnd_lookup_values flv

1247: -- Added this to get sort parameter meanings
1248: CURSOR c_get_sort_option (cp_sort_option VARCHAR2) IS
1249: SELECT flv.meaning
1250: FROM fnd_lookup_types flt ,
1251: fnd_lookup_values flv
1252: WHERE flt.lookup_type = 'PAY_MX_REG_SORT_CODE'
1253: AND flt.lookup_type = flv.lookup_type
1254: AND flv.lookup_code = cp_sort_option
1255: AND flv.enabled_flag = 'Y'