DBA Data[Home] [Help]

APPS.CS_MULTIORG_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 94: FROM hz_cust_acct_sites_all

90: CURSOR l_get_org_from_prime_accsite(p_party_site_id IN NUMBER
91: ,p_account_id IN NUMBER) IS
92:
93: SELECT org_id
94: FROM hz_cust_acct_sites_all
95: WHERE party_site_id = p_party_site_id
96: AND cust_account_id = p_account_id
97: AND bill_to_flag = 'P';
98:

Line 103: FROM hz_cust_acct_sites_all

99: CURSOR l_get_org_from_accsite(p_party_site_id IN NUMBER
100: ,p_account_id IN NUMBER) IS
101:
102: SELECT org_id
103: FROM hz_cust_acct_sites_all
104: WHERE party_site_id = p_party_site_id
105: AND cust_account_id = p_account_id
106: AND bill_to_flag = 'Y';
107: