DBA Data[Home] [Help]

APPS.AR_BILLS_CREATION_LIB_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 167: FROM hz_cust_account_roles acct_role,

163: /* modified for tca uptake */
164: /* fix bug 1883538: replace current role state with status column */
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'