eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LTE_INT_PVT dependencies on OKL_LATE_POLICIES_V

Line 44: l_late_policy okl_late_policies_v.name%TYPE;

40: --start code pgomes 12/18/2002
41: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
42: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
43: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
44: l_late_policy okl_late_policies_v.name%TYPE;
45: l_prev_late_policy okl_late_policies_v.name%TYPE;
46:
47: l_minimum_late_interest okl_late_policies_b.minimum_late_interest%TYPE;
48: l_maximum_late_interest okl_late_policies_b.maximum_late_interest%TYPE;

Line 45: l_prev_late_policy okl_late_policies_v.name%TYPE;

41: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
42: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
43: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
44: l_late_policy okl_late_policies_v.name%TYPE;
45: l_prev_late_policy okl_late_policies_v.name%TYPE;
46:
47: l_minimum_late_interest okl_late_policies_b.minimum_late_interest%TYPE;
48: l_maximum_late_interest okl_late_policies_b.maximum_late_interest%TYPE;
49: l_late_int_minimum_balance okl_late_policies_b.late_int_minimum_balance%TYPE;

Line 67: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;

63: ------------------------------------------------------------
64: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
65:
66: -- Variables for Late Interest rules Call
67: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
68: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
69: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
70: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
71: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;

Line 68: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;

64: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
65:
66: -- Variables for Late Interest rules Call
67: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
68: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
69: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
70: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
71: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;
72: l_days_calc NUMBER := 0;

Line 69: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;

65:
66: -- Variables for Late Interest rules Call
67: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
68: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
69: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
70: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
71: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;
72: l_days_calc NUMBER := 0;
73: l_held_until_date DATE;

Line 71: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;

67: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
68: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
69: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
70: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
71: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;
72: l_days_calc NUMBER := 0;
73: l_held_until_date DATE;
74:
75: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;

Line 133: , OKL_LATE_POLICIES_V LTE

129: , OKC_RULE_GROUPS_B RGP
130: , OKC_RULES_B RUL
131: , okc_rules_b rul_exm
132: ,okc_rules_b rul_hld
133: , OKL_LATE_POLICIES_V LTE
134: , AR_CASH_RECEIPTS_ALL CRA
135: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
136: , OKL_TXD_AR_LN_DTLS_B TXD
137: , AR_DISTRIBUTIONS_ALL AD

Line 206: , OKL_LATE_POLICIES_V LTE

202: , OKC_RULE_GROUPS_B RGP
203: , OKC_RULES_B RUL
204: , okc_rules_b rul_exm
205: ,okc_rules_b rul_hld
206: , OKL_LATE_POLICIES_V LTE
207: , AR_CASH_RECEIPTS_ALL CRA
208: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
209: , RA_CUSTOMER_TRX_LINES_ALL RACTRL_TAX
210: , OKL_TXD_AR_LN_DTLS_B TXD

Line 292: , OKL_LATE_POLICIES_V LTE

288: , OKC_RULE_GROUPS_B RGP
289: , OKC_RULES_B RUL
290: , okc_rules_b rul_exm
291: ,okc_rules_b rul_hld
292: , OKL_LATE_POLICIES_V LTE
293: , AR_CASH_RECEIPTS_ALL CRA
294: WHERE
295: CRA.RECEIPT_DATE > (AR_PAY.DUE_DATE + nvl(LTE.late_int_grace_period, 0)) AND
296: CNSLD.RECEIVABLES_INVOICE_ID = AR_PAY.CUSTOMER_TRX_ID

Line 352: FROM OKL_LATE_POLICIES_V LTE

348: , NVL(LTE.MINIMUM_LATE_INTEREST,0) MINIMUM_LATE_INTEREST
349: , NVL(LTE.MAXIMUM_LATE_INTEREST,9999999999) MAXIMUM_LATE_INTEREST
350: , NVL(IDX.value,0) INDEX_RATE
351: , NVL(LTE.DAYS_IN_YEAR, 'ACTUAL') DAYS_IN_YEAR
352: FROM OKL_LATE_POLICIES_V LTE
353: , OKL_INDEX_VALUES IDX
354: WHERE LTE.NAME = cp_name
355: AND LTE.idx_id = IDX.idx_id(+)
356: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(IDX.DATETIME_VALID, SYSDATE)) AND TRUNC(NVL(IDX.DATETIME_INVALID, SYSDATE));