DBA Data[Home] [Help]

APPS.AR_BILLS_CREATION_LIB_PVT dependencies on HZ_CUST_SITE_USES

Line 105: FROM hz_cust_site_uses site_uses,

101:
102: /* modified for tca uptake */
103: SELECT site_uses.SITE_USE_ID
104: INTO p_drawee_site_use_id
105: FROM hz_cust_site_uses site_uses,
106: hz_cust_acct_sites acct_site
107: WHERE acct_site.cust_account_id = p_drawee_id
108: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
109: AND site_uses.site_use_code = 'DRAWEE'

Line 169: HZ_CUST_SITE_USES site_uses

165: SELECT acct_role.cust_account_role_id
166: INTO p_drawee_contact_id
167: FROM hz_cust_account_roles acct_role,
168: hz_role_responsibility role_res,
169: HZ_CUST_SITE_USES site_uses
170: WHERE acct_role.cust_account_id = p_drawee_id
171: AND nvl(acct_role.status, 'I') = 'A'
172: AND acct_role.cust_acct_site_id = site_uses.cust_acct_site_id
173: AND site_uses.site_use_id = p_drawee_site_use_id