APPS.PV_PARTNER_ACCNT_MGMT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 195: FROM hz_cust_acct_sites

191:
192: -- acct site need not be verified
193: CURSOR C_acct_site (l_account_id NUMBER, l_site_id NUMBER) IS
194: SELECT cust_acct_site_id
195: FROM hz_cust_acct_sites
196: WHERE cust_account_id = l_Account_Id
197: AND party_site_id = l_Site_Id;
198:
199: p_acct_site_Rec HZ_CUST_ACCOUNT_SITE_V2PUB.cust_acct_site_rec_type;

Line 937: from hz_cust_site_uses a, hz_cust_acct_sites b

933: IS
934:
935: CURSOR site_use_cur IS
936: select a.site_use_id, a.cust_acct_site_id
937: from hz_cust_site_uses a, hz_cust_acct_sites b
938: where b.cust_account_id = p_cust_account_id
939: and b.party_site_id = p_party_site_id
940: and a.cust_acct_site_id = b.cust_acct_site_id
941: and a.site_use_code = p_acct_site_type

Line 1012: from hz_cust_account_roles a, hz_cust_acct_sites c

1008:
1009:
1010: CURSOR cust_role IS
1011: select a.cust_account_role_id
1012: from hz_cust_account_roles a, hz_cust_acct_sites c
1013: where a.role_type = 'CONTACT'
1014: and a.party_id = p_contact_party_id
1015: and a.cust_account_id = p_cust_account_id
1016: and a.cust_acct_site_id = c.cust_acct_site_id