APPS.QP_SOURCING_API_PUB dependencies on HZ_CUST_SITE_USES

Line 58: FROM hz_cust_site_uses hsu

54:
55: BEGIN
56: SELECT NVL(gsa_indicator,'N')
57: INTO G_Customer_Info.gsa_indicator
58: FROM hz_cust_site_uses hsu
59: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id
60: --added for moac
61: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;
62: /*

Line 1325: hz_cust_site_uses b

1321:
1322: CURSOR get_ship_to_site_id_cur (l_ship_to_org_id NUMBER) IS
1323: SELECT a.party_site_id
1324: FROM hz_cust_acct_sites a,
1325: hz_cust_site_uses b
1326: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1327: AND b.site_use_id = l_ship_to_org_id
1328: AND b.site_use_code = 'SHIP_TO';
1329:

Line 1350: hz_cust_site_uses b

1346:
1347: CURSOR get_bill_to_site_id_cur (l_bill_to_org_id NUMBER) IS
1348: SELECT a.party_site_id
1349: FROM hz_cust_acct_sites a,
1350: hz_cust_site_uses b
1351: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1352: AND b.site_use_id = l_bill_to_org_id
1353: AND b.site_use_code = 'BILL_TO';
1354:

Line 1652: FROM hz_cust_site_uses hsu

1648:
1649: BEGIN
1650: SELECT NVL(gsa_indicator,'N')
1651: INTO G_Customer_Info.gsa_indicator
1652: FROM hz_cust_site_uses hsu
1653: WHERE site_use_id = invoice_to_org_id
1654: --added for moac
1655: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;
1656: /*