APPS.ARP_PROGRAM_GENERATE_BR dependencies on HZ_CUST_ACCT_SITES

Line 1790: FROM hz_cust_acct_sites a,

1786:
1787: l_trx_select_statement := l_trx_select_statement ||
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:

Line 1906: - remove join to hz_cust_acct_sites, this is done in construct_hz

1902: - replace trx.trx_date with ps.trx_date
1903: - replace (ps.due_date - pm.lead_days) <= SYSDATE
1904: with ps.due_date <= SYSDATE + pm.lead_days
1905: - use NOT EXISTS in check against ra_customer_trx_lines
1906: - remove join to hz_cust_acct_sites, this is done in construct_hz
1907: */
1908: /* Bug 4928711 - Removed the references to ap_bank_accounts */
1909:
1910: l_trx_select_statement :=

Line 3161: hz_cust_acct_sites acct_site,

3157: site_uses.contact_id,
3158: Null external_bank_account_id
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

Line 3181: hz_cust_acct_sites acct_site,

3177: site_uses.contact_id,
3178: Null external_bank_account_id
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

Line 3194: hz_cust_acct_sites bacct_site,

3190: AND acct_site.party_site_id = party_site.party_site_id
3191: AND party_site.location_id =
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

Line 3242: hz_cust_acct_sites acct_site,

3238:
3239: SELECT site_uses.site_use_id, site_uses.contact_id, acct_site.cust_acct_site_id
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

Line 3260: hz_cust_acct_sites acct_site,

3256:
3257: SELECT site_uses.site_use_id
3258: INTO l_bill_to_site_id
3259: FROM hz_cust_accounts cust_acct,
3260: hz_cust_acct_sites acct_site,
3261: hz_cust_site_uses site_uses
3262: WHERE cust_acct.cust_account_id = l_drawee_id
3263: AND cust_acct.cust_account_id = acct_site.cust_account_id
3264: AND acct_site.cust_acct_site_id = l_site_id

Line 3320: hz_cust_acct_sites acct_site,

3316: site_uses.contact_id,
3317: p_customer_bank_account_id
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

Line 3334: hz_cust_acct_sites bacct_site,

3330: AND acct_site.party_site_id = party_site.party_site_id
3331: AND party_site.location_id =
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