APPS.OZF_QP_QUAL_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 749: FROM hz_cust_site_uses_all

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

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;