APPS.AR_LATE_CHARGE_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 1038: FROM ar_system_parameters;

1034: LATE_CHARGE_INV_TYPE_ID,
1035: ALLOW_LATE_CHARGES,
1036: PENALTY_REC_TRX_ID,
1037: FINCHRG_RECEIVABLES_TRX_ID
1038: FROM ar_system_parameters;
1039: l_sp csp%ROWTYPE;
1040:
1041: CURSOR c IS
1042: SELECT NULL

Line 1128: ar_system_parameters sp,

1124: tty.GL_ID_REV,
1125: p_worker_num
1126: FROM ar_interest_headers h,
1127: ar_interest_lines l,
1128: ar_system_parameters sp,
1129: ra_cust_trx_types tty
1130: WHERE h.interest_batch_id = g_interest_batch_id
1131: AND h.INTEREST_HEADER_ID = l.INTEREST_HEADER_ID
1132: AND tty.cust_trx_type_id(+) = h.cust_trx_type_id

Line 1548: FROM ar_system_parameters;

1544: LATE_CHARGE_INV_TYPE_ID,
1545: ALLOW_LATE_CHARGES,
1546: PENALTY_REC_TRX_ID,
1547: FINCHRG_RECEIVABLES_TRX_ID
1548: FROM ar_system_parameters;
1549: l_sp csp%ROWTYPE;
1550:
1551: CURSOR c IS
1552: SELECT COUNT(*) FROM ar_late_charge_doc_gt

Line 2914: ar_system_parameters_all s,

2910: s.late_charge_batch_source_id,
2911: lg.currency_code
2912: FROM ar_interest_batches_all b,
2913: ar_interest_headers_all h,
2914: ar_system_parameters_all s,
2915: gl_ledgers lg
2916: WHERE b.request_id = p_request_id
2917: AND b.org_id = s.org_id
2918: AND b.interest_batch_id = h.interest_batch_id

Line 3540: FROM ar_system_parameters sysp,

3536: CURSOR c_initial IS
3537: SELECT lg.currency_code,
3538: sysp.org_id,
3539: sysp.LATE_CHARGE_BATCH_SOURCE_ID
3540: FROM ar_system_parameters sysp,
3541: gl_ledgers lg
3542: WHERE lg.ledger_id = sysp.set_of_books_id;
3543: BEGIN
3544: