APPS.PA_CUSTOMER_INFO dependencies on HZ_CUST_ACCT_SITES_ALL

Line 73: FROM hz_cust_acct_sites_all acct_site,

69: */
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'

Line 103: hz_cust_acct_sites_all acct_site,

99:
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'

Line 133: hz_cust_acct_sites_all acct_site,

129:
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'

Line 913: hz_cust_acct_sites_all acct_site,

909:
910: SELECT 'Y'
911: INTO l_return_value
912: FROM
913: hz_cust_acct_sites_all acct_site,
914: hz_cust_site_uses su
915: WHERE
916: acct_site.cust_acct_site_id = su.cust_acct_site_id
917: AND Nvl(acct_site.Status,'A') = 'A'

Line 1038: hz_cust_acct_sites_all acct_site

1034: INTO l_return_value
1035: FROM
1036: hz_cust_account_roles acct_role ,
1037: hz_role_responsibility hrrep ,
1038: hz_cust_acct_sites_all acct_site
1039: WHERE acct_role.cust_account_id = l_Customer_Id
1040: and acct_role.cust_account_role_id = hrrep.cust_account_role_id
1041: and acct_role.cust_account_role_id = l_Contact_Id
1042: and hrrep.responsibility_type = l_site_use_code