APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_API_OWNER_STATUSES

Line 2575: INSERT INTO zx_api_owner_statuses (

2571: AND api.api_owner_id = ru.first_pty_org_id
2572: );
2573:
2574:
2575: INSERT INTO zx_api_owner_statuses (
2576: API_OWNER_ID,
2577: SERVICE_CATEGORY_CODE,
2578: STATUS_CODE,
2579: CREATION_DATE,

Line 2599: FROM ZX_API_OWNER_STATUSES sts

2595: WHERE ru.regime_usage_id = p_regime_usage_id
2596: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2597: AND srvc.regime_usage_id = ru.regime_usage_id
2598: AND NOT EXISTS (SELECT 1
2599: FROM ZX_API_OWNER_STATUSES sts
2600: WHERE sts.api_owner_id = ru.first_pty_org_id
2601: );
2602:
2603: if(p_code_generator_flag = 'Y') then