DBA Data[Home] [Help]

APPS.ZX_TPI_PLUGIN_PKG dependencies on ZX_SERVICE_TYPES

Line 55: , zx_service_types b

51: , b.service_type_id
52: , b.service_type_code
53: , b.data_transfer_code
54: FROM zx_api_registrations a
55: , zx_service_types b
56: , zx_api_owner_statuses c
57: WHERE a.service_type_id = b.service_type_id
58: AND a.api_owner_id = c.api_owner_id
59: AND upper(c.service_category_code) = upper(p_srvc_cat)

Line 77: , zx_service_types b

73: , a.package_name
74: , a.procedure_name
75: , b.service_type_code
76: FROM zx_api_registrations a
77: , zx_service_types b
78: , zx_api_owner_statuses c
79: WHERE a.service_type_id = b.service_type_id
80: and a.api_owner_id = c.api_owner_id
81: and upper(c.service_category_code) = upper(p_srvc_cat)