APPS.OZF_QP_QUAL_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 771: FROM hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa

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

Line 1456: FROM hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa

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