DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 743: FROM hz_cust_acct_sites_all a,

739: AND inst.cle_id = p_kle_top_line;
740:
741: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
742: SELECT a.CUST_ACCT_SITE_ID
743: FROM hz_cust_acct_sites_all a,
744: hz_cust_site_uses_all b,
745: hz_party_sites c
746: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
747: b.site_use_code = 'SHIP_TO' AND

Line 1199: FROM hz_cust_acct_sites_all a,

1195: AND inst.cle_id = p_kle_top_line;
1196:
1197: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
1198: SELECT a.CUST_ACCT_SITE_ID
1199: FROM hz_cust_acct_sites_all a,
1200: hz_cust_site_uses_all b,
1201: hz_party_sites c
1202: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
1203: b.site_use_code = 'SHIP_TO' AND