DBA Data[Home] [Help]

APPS.HZ_ACT_UTIL_PUB dependencies on HZ_CUST_SITE_USES

Line 14: hz_cust_site_uses asu,

10:
11: cursor c_site_use_purposes (l_act_site_id IN NUMBER) is
12: select al.MEANING
13: from hz_cust_acct_sites asite,
14: hz_cust_site_uses asu,
15: ar_lookups al
16: where asite.cust_acct_site_id = l_act_site_id
17: and asu.status = 'A'
18: and asu.cust_acct_site_id = asite.cust_acct_site_id

Line 64: hz_cust_site_uses asu,

60:
61: cursor c_site_use_purposes (l_act_site_id IN NUMBER) is
62: select al.MEANING
63: from hz_cust_acct_sites asite,
64: hz_cust_site_uses asu,
65: ar_lookups al
66: where asite.cust_acct_site_id = l_act_site_id
67: and asu.cust_acct_site_id = asite.cust_acct_site_id
68: and al.lookup_type = 'SITE_USE_CODE'