APPS.ARP_PROGRAM_GENERATE_BR dependencies on HZ_PARTY_SITES

Line 3328: hz_party_sites party_site

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

Line 3340: hz_party_sites bparty_site,

3336: (select bloc.location_id
3337: FROM hz_cust_accounts bcust_acct,
3338: hz_cust_acct_sites bacct_site,
3339: hz_cust_site_uses bsite_uses,
3340: hz_party_sites bparty_site,
3341: hz_locations bloc
3342: WHERE bcust_acct.cust_account_id = l_drawee_id
3343: AND bcust_acct.cust_account_id = bacct_site.cust_account_id
3344: AND bacct_site.cust_acct_site_id = bsite_uses.cust_acct_site_id

Line 3467: hz_party_sites party_site

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

Line 3480: hz_party_sites bparty_site,

3476: (select bloc.location_id
3477: FROM hz_cust_accounts bcust_acct,
3478: hz_cust_acct_sites bacct_site,
3479: hz_cust_site_uses bsite_uses,
3480: hz_party_sites bparty_site,
3481: hz_locations bloc
3482: WHERE bcust_acct.cust_account_id = l_drawee_id
3483: AND bcust_acct.cust_account_id = bacct_site.cust_account_id
3484: AND bacct_site.cust_acct_site_id = bsite_uses.cust_acct_site_id