APPS.ARP_PROGRAM_GENERATE_BR dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1941: hz_cust_account_roles acct_role

1937: ' AND exists
1938: (SELECT a.cust_account_id
1939: FROM hz_cust_acct_sites a,
1940: hz_cust_site_uses site,
1941: hz_cust_account_roles acct_role
1942: WHERE a.cust_acct_site_id = site.cust_acct_site_id ';
1943:
1944: if p_customer_id is NOT NULL then
1945: l_trx_select_statement := l_trx_select_statement ||

Line 3307: hz_cust_account_roles acct_role

3303: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3304: FROM hz_cust_accounts cust_acct,
3305: hz_cust_acct_sites acct_site,
3306: hz_cust_site_uses site_uses,
3307: hz_cust_account_roles acct_role
3308: WHERE cust_acct.cust_account_id = l_drawee_id
3309: AND cust_acct.cust_account_id = acct_site.cust_account_id
3310: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
3311: AND site_uses.site_use_code = 'DRAWEE'

Line 3327: hz_cust_account_roles acct_role,

3323: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3324: FROM hz_cust_accounts cust_acct,
3325: hz_cust_acct_sites acct_site,
3326: hz_cust_site_uses site_uses,
3327: hz_cust_account_roles acct_role,
3328: hz_party_sites party_site
3329: WHERE cust_acct.cust_account_id = l_drawee_id
3330: AND cust_acct.cust_account_id = acct_site.cust_account_id
3331: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3388: hz_cust_account_roles acct_role

3384: INTO l_drawee_site_use_id, l_drawee_contact_id, l_site_id
3385: FROM hz_cust_accounts cust_acct,
3386: hz_cust_acct_sites acct_site,
3387: hz_cust_site_uses site_uses,
3388: hz_cust_account_roles acct_role
3389: WHERE cust_acct.cust_account_id = l_drawee_id
3390: AND cust_acct.cust_account_id = acct_site.cust_account_id
3391: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
3392: AND site_uses.site_use_code = 'DRAWEE'

Line 3466: hz_cust_account_roles acct_role,

3462: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3463: FROM hz_cust_accounts cust_acct,
3464: hz_cust_acct_sites acct_site,
3465: hz_cust_site_uses site_uses,
3466: hz_cust_account_roles acct_role,
3467: hz_party_sites party_site
3468: WHERE cust_acct.cust_account_id = l_drawee_id
3469: AND cust_acct.cust_account_id = acct_site.cust_account_id
3470: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id