APPS.ARP_PROGRAM_GENERATE_BR dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1792: hz_cust_account_roles acct_role

1788: ' AND exists
1789: (SELECT a.cust_account_id
1790: FROM hz_cust_acct_sites a,
1791: hz_cust_site_uses site,
1792: hz_cust_account_roles acct_role
1793: WHERE a.cust_acct_site_id = site.cust_acct_site_id ';
1794:
1795: if p_customer_id is NOT NULL then
1796: l_trx_select_statement := l_trx_select_statement ||

Line 3163: hz_cust_account_roles acct_role

3159: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3160: FROM hz_cust_accounts cust_acct,
3161: hz_cust_acct_sites acct_site,
3162: hz_cust_site_uses site_uses,
3163: hz_cust_account_roles acct_role
3164: WHERE cust_acct.cust_account_id = l_drawee_id
3165: AND cust_acct.cust_account_id = acct_site.cust_account_id
3166: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
3167: AND site_uses.site_use_code = 'DRAWEE'

Line 3183: hz_cust_account_roles acct_role,

3179: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3180: FROM hz_cust_accounts cust_acct,
3181: hz_cust_acct_sites acct_site,
3182: hz_cust_site_uses site_uses,
3183: hz_cust_account_roles acct_role,
3184: hz_party_sites party_site
3185: WHERE cust_acct.cust_account_id = l_drawee_id
3186: AND cust_acct.cust_account_id = acct_site.cust_account_id
3187: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3244: hz_cust_account_roles acct_role

3240: INTO l_drawee_site_use_id, l_drawee_contact_id, l_site_id
3241: FROM hz_cust_accounts cust_acct,
3242: hz_cust_acct_sites acct_site,
3243: hz_cust_site_uses site_uses,
3244: hz_cust_account_roles acct_role
3245: WHERE cust_acct.cust_account_id = l_drawee_id
3246: AND cust_acct.cust_account_id = acct_site.cust_account_id
3247: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
3248: AND site_uses.site_use_code = 'DRAWEE'

Line 3322: hz_cust_account_roles acct_role,

3318: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3319: FROM hz_cust_accounts cust_acct,
3320: hz_cust_acct_sites acct_site,
3321: hz_cust_site_uses site_uses,
3322: hz_cust_account_roles acct_role,
3323: hz_party_sites party_site
3324: WHERE cust_acct.cust_account_id = l_drawee_id
3325: AND cust_acct.cust_account_id = acct_site.cust_account_id
3326: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id