APPS.OZF_QP_QUAL_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 768: FROM hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa

764: AND jqtu.qual_type_id = -1007;
765:
766: CURSOR c_party_site_id(p_ship_to_org_id NUMBER) IS
767: SELECT hzcasa.party_site_id
768: FROM hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa
769: WHERE hzcasa.cust_acct_site_id = hzcsua.cust_acct_site_id
770: AND hzcsua.site_use_id = p_ship_to_org_id;
771:
772: l_party_id NUMBER;

Line 1453: FROM hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa

1449: AND jqtu.qual_type_id = -1002;
1450:
1451: CURSOR c_party_site_id(p_ship_to_org_id NUMBER) IS
1452: SELECT hzcasa.party_site_id
1453: FROM hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa
1454: WHERE hzcasa.cust_acct_site_id = hzcsua.cust_acct_site_id
1455: AND hzcsua.site_use_id = p_ship_to_org_id;
1456:
1457: l_party_id NUMBER;