DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_API_OWNER_STATUSES

Line 2529: INSERT INTO zx_api_owner_statuses (

2525: AND api.api_owner_id = ru.first_pty_org_id
2526: );
2527:
2528:
2529: INSERT INTO zx_api_owner_statuses (
2530: API_OWNER_ID,
2531: SERVICE_CATEGORY_CODE,
2532: STATUS_CODE,
2533: CREATION_DATE,

Line 2553: FROM ZX_API_OWNER_STATUSES sts

2549: WHERE ru.regime_usage_id = p_regime_usage_id
2550: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2551: AND srvc.regime_usage_id = ru.regime_usage_id
2552: AND NOT EXISTS (SELECT 1
2553: FROM ZX_API_OWNER_STATUSES sts
2554: WHERE sts.api_owner_id = ru.first_pty_org_id
2555: );
2556:
2557: if(p_code_generator_flag = 'Y') then