DBA Data[Home] [Help]

APPS.ZX_API_PRVDR_PUB dependencies on ZX_API_CODE_COMBINATIONS

Line 197: FROM zx_api_code_combinations

193: /*Check if combination of business group and regime exists in zx_api_combinations*/
194: BEGIN
195: SELECT code_combination_id
196: INTO l_code_combination_id
197: FROM zx_api_code_combinations
198: WHERE segment_attribute1 = p_country_code
199: AND segment_attribute2 = p_business_flow;
200:
201: EXCEPTION

Line 412: zx_api_code_combinations cmbn,

408:
409: DELETE from ZX_API_REGISTRATIONS
410: WHERE EXISTS (SELECT *
411: FROM zx_api_registrations reg,
412: zx_api_code_combinations cmbn,
413: zx_service_types srvc
414: WHERE reg.api_owner_id = l_api_owner_id
415: AND srvc.service_type_id = reg.service_type_id
416: AND srvc.service_type_code = p_srvc_type_code