DBA Data[Home] [Help]

APPS.XLE_UTILITIES_GRP dependencies on XLE_LOOKUPS

Line 2039: XLE_LOOKUPS fndlookup

2035: fndlookup.lookup_type class_category,
2036: fndlookup.lookup_code class_code,
2037: fndlookup.meaning meaning
2038: FROM XLE_ETB_PROFILES etbp,
2039: XLE_LOOKUPS fndlookup
2040: WHERE etbp.party_id = p_party_id
2041: AND fndlookup.lookup_code = etbp.etb_information1
2042: AND NVL(fndlookup.START_DATE_ACTIVE, SYSDATE) <= SYSDATE
2043: AND NVL(fndlookup.END_DATE_ACTIVE, SYSDATE) >= SYSDATE

Line 2054: XLE_LOOKUPS fndlookup

2050: fndlookup.lookup_type class_category,
2051: fndlookup.lookup_code class_code,
2052: fndlookup.meaning meaning
2053: FROM XLE_ETB_PROFILES etbp,
2054: XLE_LOOKUPS fndlookup
2055: WHERE etbp.party_id = p_party_id
2056: AND fndlookup.lookup_code = etbp.etb_information2
2057: AND NVL(fndlookup.START_DATE_ACTIVE, SYSDATE) <= SYSDATE
2058: AND NVL(fndlookup.END_DATE_ACTIVE, SYSDATE) >= SYSDATE

Line 2766: xle_lookups lkp

2762: INTO l_count
2763: FROM
2764: xle_reg_functions reg_func,
2765: xle_registrations reg,
2766: xle_lookups lkp
2767: WHERE
2768: lkp.lookup_type = 'XLE_LE_FUNCTION'
2769: AND lkp.lookup_code = reg_func.function_code
2770: AND lkp.lookup_code = 'ICINV'

Line 2794: xle_lookups lkp ,

2790: INTO l_count
2791: FROM
2792: xle_reg_functions reg_func,
2793: xle_registrations reg,
2794: xle_lookups lkp ,
2795: xle_entity_profiles ent_prof
2796: WHERE
2797: lkp.lookup_type = 'XLE_LE_FUNCTION'
2798: AND lkp.lookup_code = reg_func.function_code