APPS.AR_LATE_CHARGE_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 1066: FROM ar_system_parameters;

1062: LATE_CHARGE_INV_TYPE_ID,
1063: ALLOW_LATE_CHARGES,
1064: PENALTY_REC_TRX_ID,
1065: FINCHRG_RECEIVABLES_TRX_ID
1066: FROM ar_system_parameters;
1067: l_sp csp%ROWTYPE;
1068:
1069: CURSOR c IS
1070: SELECT NULL

Line 1156: ar_system_parameters sp,

1152: tty.GL_ID_REV,
1153: p_worker_num
1154: FROM ar_interest_headers h,
1155: ar_interest_lines l,
1156: ar_system_parameters sp,
1157: ra_cust_trx_types tty
1158: WHERE h.interest_batch_id = g_interest_batch_id
1159: AND h.INTEREST_HEADER_ID = l.INTEREST_HEADER_ID
1160: AND tty.cust_trx_type_id(+) = h.cust_trx_type_id

Line 1583: FROM ar_system_parameters;

1579: LATE_CHARGE_INV_TYPE_ID,
1580: ALLOW_LATE_CHARGES,
1581: PENALTY_REC_TRX_ID,
1582: FINCHRG_RECEIVABLES_TRX_ID
1583: FROM ar_system_parameters;
1584: l_sp csp%ROWTYPE;
1585:
1586: CURSOR c IS
1587: SELECT COUNT(*) FROM ar_late_charge_doc_gt

Line 2954: ar_system_parameters_all s,

2950: s.late_charge_batch_source_id,
2951: lg.currency_code
2952: FROM ar_interest_batches_all b,
2953: ar_interest_headers_all h,
2954: ar_system_parameters_all s,
2955: gl_ledgers lg
2956: WHERE b.request_id = p_request_id
2957: AND b.org_id = s.org_id
2958: AND b.interest_batch_id = h.interest_batch_id

Line 3580: FROM ar_system_parameters sysp,

3576: CURSOR c_initial IS
3577: SELECT lg.currency_code,
3578: sysp.org_id,
3579: sysp.LATE_CHARGE_BATCH_SOURCE_ID
3580: FROM ar_system_parameters sysp,
3581: gl_ledgers lg
3582: WHERE lg.ledger_id = sysp.set_of_books_id;
3583: BEGIN
3584: