APPS.QP_SOURCING_API_PUB dependencies on HZ_CUST_ACCT_SITES

Line 1332: FROM hz_cust_acct_sites a,

1328: l_ship_to_party_site_id NUMBER;
1329:
1330: CURSOR get_ship_to_site_id_cur (l_ship_to_org_id NUMBER) IS
1331: SELECT a.party_site_id
1332: FROM hz_cust_acct_sites a,
1333: hz_cust_site_uses b
1334: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1335: AND b.site_use_id = l_ship_to_org_id
1336: AND b.site_use_code = 'SHIP_TO';

Line 1357: FROM hz_cust_acct_sites a,

1353: l_bill_to_party_site_id NUMBER;
1354:
1355: CURSOR get_bill_to_site_id_cur (l_bill_to_org_id NUMBER) IS
1356: SELECT a.party_site_id
1357: FROM hz_cust_acct_sites a,
1358: hz_cust_site_uses b
1359: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1360: AND b.site_use_id = l_bill_to_org_id
1361: AND b.site_use_code = 'BILL_TO';