APPS.ARP_PROGRAM_GENERATE_BR dependencies on HZ_PARTY_SITES

Line 3184: hz_party_sites party_site

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
3188: AND site_uses.site_use_code = 'DRAWEE'

Line 3196: hz_party_sites bparty_site,

3192: (select bloc.location_id
3193: FROM hz_cust_accounts bcust_acct,
3194: hz_cust_acct_sites bacct_site,
3195: hz_cust_site_uses bsite_uses,
3196: hz_party_sites bparty_site,
3197: hz_locations bloc
3198: WHERE bcust_acct.cust_account_id = l_drawee_id
3199: AND bcust_acct.cust_account_id = bacct_site.cust_account_id
3200: AND bacct_site.cust_acct_site_id = bsite_uses.cust_acct_site_id

Line 3323: hz_party_sites party_site

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
3327: AND site_uses.site_use_code = 'DRAWEE'

Line 3336: hz_party_sites bparty_site,

3332: (select bloc.location_id
3333: FROM hz_cust_accounts bcust_acct,
3334: hz_cust_acct_sites bacct_site,
3335: hz_cust_site_uses bsite_uses,
3336: hz_party_sites bparty_site,
3337: hz_locations bloc
3338: WHERE bcust_acct.cust_account_id = l_drawee_id
3339: AND bcust_acct.cust_account_id = bacct_site.cust_account_id
3340: AND bacct_site.cust_acct_site_id = bsite_uses.cust_acct_site_id