DBA Data[Home] [Help]

APPS.CS_MULTIORG_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 95: FROM hz_cust_acct_sites_all

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

Line 104: FROM hz_cust_acct_sites_all

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