DBA Data[Home] [Help]

APPS.ZX_TPI_PLUGIN_PKG dependencies on ZX_SERVICE_TYPES

Line 42: , zx_service_types b

38: , b.service_type_id
39: , b.service_type_code
40: , b.data_transfer_code
41: FROM zx_api_registrations a
42: , zx_service_types b
43: , zx_api_owner_statuses c
44: WHERE a.service_type_id = b.service_type_id
45: AND a.api_owner_id = c.api_owner_id
46: AND upper(c.service_category_code) = upper(p_srvc_cat)

Line 64: , zx_service_types b

60: , a.package_name
61: , a.procedure_name
62: , b.service_type_code
63: FROM zx_api_registrations a
64: , zx_service_types b
65: , zx_api_owner_statuses c
66: WHERE a.service_type_id = b.service_type_id
67: and a.api_owner_id = c.api_owner_id
68: and upper(c.service_category_code) = upper(p_srvc_cat)