DBA Data[Home] [Help]

APPS.XLE_UTILITIES_GRP dependencies on XLE_LOOKUPS

Line 2041: XLE_LOOKUPS fndlookup

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

Line 2056: XLE_LOOKUPS fndlookup

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

Line 2768: xle_lookups lkp

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

Line 2796: xle_lookups lkp ,

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