APPS.ASO_CHECK_TCA_PVT dependencies on HZ_CUST_SITE_USES

Line 426: select cust_acct_site_id from hz_cust_site_uses

422: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
423: IS
424:
425: CURSOR get_cust_acct_site_id(l_site_use_id number) IS
426: select cust_acct_site_id from hz_cust_site_uses
427: where site_use_id = l_site_use_id;
428:
429: CURSOR C_Site_Use(l_sold_to_party_site NUMBER) IS
430: SELECT party_site_use_id

Line 1005: select cust_acct_site_id from hz_cust_site_uses

1001: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
1002: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
1003:
1004: CURSOR get_cust_acct_site_id(l_site_use_id number) IS
1005: select cust_acct_site_id from hz_cust_site_uses
1006: where site_use_id = l_site_use_id;
1007:
1008: CURSOR C_Get_Sold_To_Info(qte_hdr NUMBER) IS
1009: SELECT cust_account_id, cust_party_id

Line 1960: hz_cust_site_uses

1956:
1957: CURSOR active_site_use_cur(l_acct_site_id NUMBER, l_site_type VARCHAR2) IS
1958: select site_use_id, status
1959: from
1960: hz_cust_site_uses
1961: where
1962: cust_acct_site_id = l_acct_site_id
1963: and site_use_code = l_site_type
1964: and status = 'A';

Line 1969: hz_cust_site_uses

1965:
1966: CURSOR inactive_site_use_cur(l_acct_site_id NUMBER, l_site_type VARCHAR2) IS
1967: select site_use_id, status
1968: from
1969: hz_cust_site_uses
1970: where
1971: cust_acct_site_id = l_acct_site_id
1972: and site_use_code = l_site_type
1973: and status <> 'A';

Line 1980: hz_cust_site_uses a, hz_cust_acct_sites b

1976: /*
1977: CURSOR site_use_cur(cust_acct NUMBER, party_site NUMBER, site_type VARCHAR2) IS
1978: select a.site_use_id, b.status,a.status
1979: from
1980: hz_cust_site_uses a, hz_cust_acct_sites b
1981: where
1982: b.cust_account_id = cust_acct
1983: and b.party_site_id = party_site
1984: and a.cust_acct_site_id = b.cust_acct_site_id