APPS.OZF_CLAIM_UTILITY_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 678: HZ_CUST_SITE_USES_ALL SITE

674: ra_customer_trx_all ct,
675: (
676: SELECT SITE.site_use_id site_use_id
677: FROM HZ_CUST_ACCT_RELATE_ALL REL, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
678: HZ_CUST_SITE_USES_ALL SITE
679: WHERE
680: REL.status = 'A'
681: AND REL.cust_account_id = p_cust_account_id --cust_account_id from deduction
682: AND (REL.relationship_type is NULL OR REL.relationship_type IN ('ALL','Reciprocal','Parent')) --For Bug 13489587 to search as ALL for having relationship_type of related customer as null.

Line 691: HZ_CUST_SITE_USES_ALL SITE

687: AND REL.org_id = l_org_id
688: UNION
689: SELECT SITE.site_use_id site_use_id
690: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
691: HZ_CUST_SITE_USES_ALL SITE
692: WHERE
693: ACCT_SITE.cust_account_id = p_cust_account_id
694: AND ACCT_SITE.cust_acct_site_id = SITE.cust_acct_site_id
695: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 752: HZ_CUST_SITE_USES_ALL SITE

748: (
749: SELECT SITE.site_use_id site_use_id
750: FROM HZ_CUST_ACCT_RELATE_ALL REL,
751: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
752: HZ_CUST_SITE_USES_ALL SITE
753: WHERE REL.status = 'A'
754: AND REL.cust_account_id = p_cust_account_id --cust_account_id from deduction
755: AND (REL.relationship_type is NULL OR REL.relationship_type IN ('ALL','Reciprocal','Parent')) --For Bug 13489587 to search as ALL for having relationship_type of related customer as null.
756: AND REL.related_cust_account_id = ACCT_SITE.cust_account_id

Line 764: HZ_CUST_SITE_USES_ALL SITE

760: AND REL.org_id = l_org_id
761: UNION
762: SELECT SITE.site_use_id site_use_id
763: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
764: HZ_CUST_SITE_USES_ALL SITE
765: WHERE ACCT_SITE.cust_account_id = p_cust_account_id
766: AND ACCT_SITE.cust_acct_site_id = SITE.cust_acct_site_id
767: AND SITE.SITE_USE_CODE = 'BILL_TO'
768: AND SITE.status = 'A'