APPS.AR_LATE_CHARGE_UPG dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 1070: l_table_name IN VARCHAR2, -- AR_SYSTEM_PARAMETERS_ALL

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

Line 1089: from ar_system_parameters_all sysp,

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

Line 1152: UPDATE ar_system_parameters_all

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