APPS.ARP_PROGRAM_GENERATE_BR dependencies on HZ_CUST_ACCT_SITES

Line 1939: FROM hz_cust_acct_sites a,

1935:
1936: l_trx_select_statement := l_trx_select_statement ||
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:

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

2051: - replace trx.trx_date with ps.trx_date
2052: - replace (ps.due_date - pm.lead_days) <= SYSDATE
2053: with ps.due_date <= SYSDATE + pm.lead_days
2054: - use NOT EXISTS in check against ra_customer_trx_lines
2055: - remove join to hz_cust_acct_sites, this is done in construct_hz
2056: */
2057: /* Bug 4928711 - Removed the references to ap_bank_accounts */
2058:
2059: l_trx_select_statement :=

Line 3305: hz_cust_acct_sites acct_site,

3301: site_uses.contact_id,
3302: Null external_bank_account_id
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

Line 3325: hz_cust_acct_sites acct_site,

3321: site_uses.contact_id,
3322: Null external_bank_account_id
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

Line 3338: hz_cust_acct_sites bacct_site,

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

Line 3386: hz_cust_acct_sites acct_site,

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

Line 3404: hz_cust_acct_sites acct_site,

3400:
3401: SELECT site_uses.site_use_id
3402: INTO l_bill_to_site_id
3403: FROM hz_cust_accounts cust_acct,
3404: hz_cust_acct_sites acct_site,
3405: hz_cust_site_uses site_uses
3406: WHERE cust_acct.cust_account_id = l_drawee_id
3407: AND cust_acct.cust_account_id = acct_site.cust_account_id
3408: AND acct_site.cust_acct_site_id = l_site_id

Line 3464: hz_cust_acct_sites acct_site,

3460: site_uses.contact_id,
3461: p_customer_bank_account_id
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

Line 3478: hz_cust_acct_sites bacct_site,

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