DBA Data[Home] [Help]

APPS.JE_ITWHYE_AP_PKG dependencies on XLE_REGISTRATIONS

Line 92: FROM xle_registrations xler,

88: ----------------------------------------------------------------------------------------------------------------------------------------------------- */
89: BEGIN
90: SELECT NVL (xler.registration_number, '') commercial_number
91: INTO cp_comm_num
92: FROM xle_registrations xler,
93: xle_jurisdictions_b xlej,
94: xle_entity_profiles xlee
95: WHERE xlej.jurisdiction_id = xler.jurisdiction_id
96: AND xlej.legislative_cat_code = 'COMMERCIAL_LAW'