APPS.AR_LATE_CHARGE_UPG dependencies on HZ_CUST_SITE_USES_ALL

Line 931: l_table_name IN VARCHAR2, -- HZ_CUST_SITE_USES_ALL

927: --Upgrade ar_payment_schedules_for_adj
928: --Phase 5
929: PROCEDURE upgrade_ps_for_adj
930: (l_table_owner IN VARCHAR2, -- AR
931: l_table_name IN VARCHAR2, -- HZ_CUST_SITE_USES_ALL
932: l_script_name IN VARCHAR2, -- ar120lccsups.sql
933: l_worker_id IN VARCHAR2,
934: l_num_workers IN VARCHAR2,
935: l_batch_size IN VARCHAR2)

Line 954: FROM hz_cust_site_uses_all csu,

950: adj.adjustment_id as adj_id,
951: psch.rowid as psch_rowid,
952: csu.last_accrue_charge_date as csu_last_charge_date,
953: rank () over (partition by adj.payment_schedule_id order by adjustment_id desc) as rk
954: FROM hz_cust_site_uses_all csu,
955: ar_payment_schedules_all psch,
956: ar_adjustments_all adj
957: WHERE csu.rowid >= p_start_rowid
958: AND csu.rowid <= p_end_rowid

Line 1244: INSERT INTO HZ_CUST_SITE_USES_ALL

1240: LOOP
1241:
1242: l_rows_processed := 0;
1243:
1244: INSERT INTO HZ_CUST_SITE_USES_ALL
1245: ( SITE_USE_ID ,
1246: CUST_ACCT_SITE_ID,
1247: SITE_USE_CODE ,
1248: PRIMARY_FLAG ,

Line 1276: hz_cust_site_uses_all csu

1272: -1551
1273: FROM (SELECT cas.cust_acct_site_id,
1274: cas.org_id
1275: FROM hz_cust_acct_sites_all cas,
1276: hz_cust_site_uses_all csu
1277: WHERE cas.rowid >= l_start_rowid
1278: AND cas.rowid <= l_end_rowid
1279: AND cas.status = 'A'
1280: AND cas.cust_acct_site_id = csu.cust_acct_site_id

Line 1283: AND NOT EXISTS (SELECT NULL FROM hz_cust_site_uses_all b WHERE

1279: AND cas.status = 'A'
1280: AND cas.cust_acct_site_id = csu.cust_acct_site_id
1281: AND csu.status = 'A'
1282: AND (( csu.site_use_code = 'STMTS'
1283: AND NOT EXISTS (SELECT NULL FROM hz_cust_site_uses_all b WHERE
1284: b.cust_acct_site_id = cas.cust_acct_site_id
1285: AND b.site_use_code = 'DUN'
1286: AND b.status = 'A'))
1287: OR csu.site_use_code = 'DUN')) l;