APPS.CSC_ROUTING_UTL dependencies on HZ_PARTY_SITES

Line 146: -- HZ_PARTY_SITES given a site number.

142: -- Function : Get_Customer_From_Site_Num
143: -- Usage : Used by the Routing module to get the customer ID from the
144: -- party site number.
145: -- Description : This function retrieves a party ID from
146: -- HZ_PARTY_SITES given a site number.
147: -- Parameters :
148: -- p_site_number IN VARCHAR2(30) Required
149: --
150: -- Return : NUMBER

Line 164: FROM hz_party_sites

160: -- get party ID given site number
161: --
162: CURSOR c_party_id (snum VARCHAR2) IS
163: SELECT party_id
164: FROM hz_party_sites
165: WHERE party_site_number = snum;
166: BEGIN
167:
168: OPEN c_party_id (p_site_number);