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:
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: