APPS.PA_CUSTOMER_INFO dependencies on HZ_CUST_SITE_USES

Line 74: hz_cust_site_uses su

70:
71: CURSOR C1 IS
72: SELECT acct_site.cust_acct_site_id, su.Contact_id, su.site_use_code
73: FROM hz_cust_acct_sites_all acct_site,
74: hz_cust_site_uses su
75: WHERE
76: acct_site.cust_acct_site_id = su.cust_acct_site_id
77: AND Nvl(acct_site.Status,'A') = 'A'
78: AND acct_site.cust_account_id = X_Customer_Id

Line 104: hz_cust_site_uses su

100: CURSOR C2 IS
101: SELECT acct_site.cust_acct_site_id, su.Contact_id, su.site_use_code
102: FROM
103: hz_cust_acct_sites_all acct_site,
104: hz_cust_site_uses su
105: WHERE
106: acct_site.cust_acct_site_id = su.cust_acct_site_id
107: AND Nvl(acct_site.Status,'A') = 'A'
108: AND acct_site.cust_account_id = X_Bill_To_Customer_Id

Line 134: hz_cust_site_uses su

130: CURSOR C3 IS
131: SELECT acct_site.cust_acct_site_id, su.Contact_id, su.site_use_code
132: FROM
133: hz_cust_acct_sites_all acct_site,
134: hz_cust_site_uses su
135: WHERE
136: acct_site.cust_acct_site_id = su.cust_acct_site_id
137: AND Nvl(acct_site.Status,'A') = 'A'
138: AND acct_site.cust_account_id = X_Ship_To_Customer_Id

Line 923: hz_cust_site_uses su

919: SELECT 'Y'
920: INTO l_return_value
921: FROM
922: hz_cust_acct_sites_all acct_site,
923: hz_cust_site_uses su
924: WHERE
925: acct_site.cust_acct_site_id = su.cust_acct_site_id
926: AND Nvl(acct_site.Status,'A') = 'A'
927: AND acct_site.cust_account_id = l_Customer_Id