APPS.GMS_MULTI_FUNDING dependencies on HZ_CUST_ACCT_SITES

Line 2160: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

2156: And su.primary_flag = 'Y' ;
2157: ****************/
2158: SELECT su.cust_acct_site_id
2159: INTO St_Bill_To_Address_Id
2160: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
2161: HZ_CUST_SITE_USES SU
2162: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
2163: AND acct_site.cust_account_id = X_Customer_Id
2164: AND Nvl(su.Status, 'A') = 'A'

Line 2212: FROM hz_cust_acct_sites acct_site,

2208: And su.primary_flag = 'Y' ;
2209: ****************/
2210: SELECT su.cust_acct_site_id
2211: INTO St_Ship_To_Address_Id
2212: FROM hz_cust_acct_sites acct_site,
2213: Hz_cust_site_Uses su
2214: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
2215: AND acct_site.cust_account_id = X_Customer_Id
2216: AND Nvl(su.Status, 'A') = 'A'

Line 2257: From hz_cust_acct_sites acct_site,

2253: BEGIN
2254: --Shared Service Enhancement : Replaced ra_contacts with HZ Table
2255: Select su.Contact_Id
2256: Into X_Ship_To_Contact_Id
2257: From hz_cust_acct_sites acct_site,
2258: Hz_cust_site_Uses su
2259: Where acct_site.cust_acct_site_id = su.cust_acct_site_id
2260: And acct_site.cust_account_id = X_Customer_Id
2261: And Nvl(su.Status, 'A') = 'A'

Line 2297: From hz_cust_acct_sites acct_site,

2293: BEGIN
2294: --Shared Service Enhancement :Replaced the RA_Contacts with HZ tables.
2295: Select su.Contact_Id
2296: Into X_Ship_To_Contact_Id
2297: From hz_cust_acct_sites acct_site,
2298: Hz_cust_site_Uses su
2299: Where acct_site.cust_acct_site_id = su.cust_acct_site_id
2300: And acct_site.cust_account_id = X_Customer_Id
2301: And Nvl(su.Status, 'A') = 'A'