APPS.AR_LATE_CHARGE_UPG dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 1068: l_table_name IN VARCHAR2, -- AR_SYSTEM_PARAMETERS_ALL

1064:
1065: --Phase 5
1066: PROCEDURE upgrade_lc_sysp
1067: (l_table_owner IN VARCHAR2, -- AR
1068: l_table_name IN VARCHAR2, -- AR_SYSTEM_PARAMETERS_ALL
1069: l_script_name IN VARCHAR2, -- ar120lcsysp.sql
1070: l_worker_id IN VARCHAR2,
1071: l_num_workers IN VARCHAR2,
1072: l_batch_size IN VARCHAR2)

Line 1087: from ar_system_parameters_all sysp,

1083: INDEX(ractt ra_cust_trx_types_u1) */
1084: sysp.rowid ,
1085: rabatch.batch_source_id,
1086: ractt.cust_trx_type_id
1087: from ar_system_parameters_all sysp,
1088: ra_batch_sources_all rabatch,
1089: ra_cust_trx_types_all ractt
1090: WHERE sysp.org_id = rabatch.org_id(+)
1091: AND rabatch.name(+)= 'Interest Invoice'

Line 1150: UPDATE ar_system_parameters_all

1146: EXIT;
1147: END IF;
1148:
1149: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
1150: UPDATE ar_system_parameters_all
1151: SET late_charge_inv_type_id = l_cust_trx_type_id(i),
1152: late_charge_batch_source_id = l_batch_source_id(i),
1153: allow_late_charges = 'Y'
1154: WHERE rowid = l_rowid_tab(i);