APPS.OZF_QP_QUAL_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 752: FROM hz_cust_site_uses_all

748: AND site_use_id IN (p_ship_to, p_bill_to);
749: /*
750: CURSOR c_site_use_code(p_site_use_id NUMBER) IS
751: SELECT site_use_code
752: FROM hz_cust_site_uses_all
753: WHERE site_use_id = p_site_use_id;
754:
755: l_index NUMBER := 0;
756: */

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;