APPS.OKS_IMPORT_VALIDATE dependencies on OKS_BILLING_PROFILES_B

Line 1532: FROM OKS_BILLING_PROFILES_B

1528: ,(CASE WHEN (HST.RENEWAL_MARKUP IS NOT NULL AND HST.PRICING_METHOD <> 'PCT')
1529: THEN 'Y' ELSE 'N' END) MKP_NULL_ERROR
1530: ,(CASE WHEN (HST.RENEWAL_BILLING_PROFILE_ID IS NOT NULL
1531: AND NOT EXISTS (SELECT 'X'
1532: FROM OKS_BILLING_PROFILES_B
1533: WHERE ID = HST.RENEWAL_BILLING_PROFILE_ID
1534: AND (OWNED_PARTY_ID1 IS NULL
1535: OR (OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID AND
1536: BILL_TO_ADDRESS_ID1 IS NULL))

Line 1539: FROM OKS_BILLING_PROFILES_B A,

1535: OR (OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID AND
1536: BILL_TO_ADDRESS_ID1 IS NULL))
1537: UNION
1538: SELECT 'X'
1539: FROM OKS_BILLING_PROFILES_B A,
1540: HZ_CUST_SITE_USES_ALL CS,
1541: HZ_PARTY_SITES PS,
1542: HZ_CUST_ACCT_SITES_ALL CA
1543: WHERE A.ID = HST.RENEWAL_BILLING_PROFILE_ID