APPS.QP_SOURCING_API_PUB dependencies on HZ_CUST_SITE_USES

Line 57: FROM hz_cust_site_uses hsu

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

Line 1333: hz_cust_site_uses b

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';
1337:

Line 1358: hz_cust_site_uses b

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';
1362:

Line 1660: FROM hz_cust_site_uses hsu

1656:
1657: BEGIN
1658: SELECT NVL(gsa_indicator,'N')
1659: INTO G_Customer_Info.gsa_indicator
1660: FROM hz_cust_site_uses hsu
1661: WHERE site_use_id = invoice_to_org_id
1662: --added for moac
1663: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;
1664: /*