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_CHRG_PVT dependencies on OKL_LATE_POLICIES_V

Line 53: l_late_policy okl_late_policies_v.name%TYPE;

49: --start code pgomes 12/18/2002
50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
53: l_late_policy okl_late_policies_v.name%TYPE;
54: l_prev_late_policy okl_late_policies_v.name%TYPE;
55:
56:
57: l_late_chrg_amount okl_late_policies_b.late_chrg_amount%TYPE;

Line 54: l_prev_late_policy okl_late_policies_v.name%TYPE;

50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
53: l_late_policy okl_late_policies_v.name%TYPE;
54: l_prev_late_policy okl_late_policies_v.name%TYPE;
55:
56:
57: l_late_chrg_amount okl_late_policies_b.late_chrg_amount%TYPE;
58: l_minimum_late_charge okl_late_policies_b.minimum_late_charge%TYPE;

Line 61: l_late_chrg_fixed_yn okl_late_policies_v.late_chrg_fixed_yn%TYPE;

57: l_late_chrg_amount okl_late_policies_b.late_chrg_amount%TYPE;
58: l_minimum_late_charge okl_late_policies_b.minimum_late_charge%TYPE;
59: l_maximum_late_charge okl_late_policies_b.maximum_late_charge%TYPE;
60: l_late_chrg_minimum_balance okl_late_policies_b.late_chrg_minimum_balance%TYPE;
61: l_late_chrg_fixed_yn okl_late_policies_v.late_chrg_fixed_yn%TYPE;
62: l_late_chrg_allowed_yn okl_late_policies_v.late_chrg_allowed_yn%TYPE;
63: l_late_chrg_rate okl_late_policies_v.late_chrg_rate%TYPE;
64:
65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;

Line 62: l_late_chrg_allowed_yn okl_late_policies_v.late_chrg_allowed_yn%TYPE;

58: l_minimum_late_charge okl_late_policies_b.minimum_late_charge%TYPE;
59: l_maximum_late_charge okl_late_policies_b.maximum_late_charge%TYPE;
60: l_late_chrg_minimum_balance okl_late_policies_b.late_chrg_minimum_balance%TYPE;
61: l_late_chrg_fixed_yn okl_late_policies_v.late_chrg_fixed_yn%TYPE;
62: l_late_chrg_allowed_yn okl_late_policies_v.late_chrg_allowed_yn%TYPE;
63: l_late_chrg_rate okl_late_policies_v.late_chrg_rate%TYPE;
64:
65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;
66:

Line 63: l_late_chrg_rate okl_late_policies_v.late_chrg_rate%TYPE;

59: l_maximum_late_charge okl_late_policies_b.maximum_late_charge%TYPE;
60: l_late_chrg_minimum_balance okl_late_policies_b.late_chrg_minimum_balance%TYPE;
61: l_late_chrg_fixed_yn okl_late_policies_v.late_chrg_fixed_yn%TYPE;
62: l_late_chrg_allowed_yn okl_late_policies_v.late_chrg_allowed_yn%TYPE;
63: l_late_chrg_rate okl_late_policies_v.late_chrg_rate%TYPE;
64:
65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;
66:
67: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;

Line 125: ,okl_late_policies_v lte

121: ,okc_rule_groups_b rgp
122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm
124: ,okc_rules_b rul_hld
125: ,okl_late_policies_v lte
126: where lpt.invoice_id=lpt1.invoice_id
127: and lpt.pay_sch_class = 'INV'
128: AND lpt.STATUS = 'OP'
129: and nvl(lpt1.late_charge_ass_yn, 'N') = 'N'

Line 179: ,okl_late_policies_v lte

175: ,okc_rule_groups_b rgp
176: ,okc_rules_b rul
177: ,okc_rules_b rul_exm
178: ,okc_rules_b rul_hld
179: ,okl_late_policies_v lte
180: where PS.CLASS IN ('INV', 'CM')
181: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
182: AND LN.ID = ST.LLN_ID
183: AND HD.ID = LN.CNR_ID

Line 266: ,okl_late_policies_v lte

262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul
264: ,okc_rules_b rul_exm
265: ,okc_rules_b rul_hld
266: ,okl_late_policies_v lte
267: WHERE last_arl.sel_id = sel.id
268: and orig_arv.pay_sch_class = 'INV'
269: AND orig_arv.STATUS = 'OP'
270: and orig_arl.receivables_invoice_id = sel.source_id

Line 373: ,okl_late_policies_v lte

369: ,okc_rule_groups_b rgp
370: ,okc_rules_b rul
371: ,okc_rules_b rul_exm
372: ,okc_rules_b rul_hld
373: ,okl_late_policies_v lte
374: where last.sel_id = sel.id
375: and orig.class = 'INV'
376: and orig.status = 'OP'
377: and orig.consolidated_invoice_id = sel.source_id

Line 420: FROM OKL_LATE_POLICIES_V

416: , NVL(LATE_CHRG_GRACE_PERIOD,0) LATE_CHRG_GRACE_PERIOD
417: , NVL(LATE_CHRG_MINIMUM_BALANCE, 0) LATE_CHRG_MINIMUM_BALANCE
418: , NVL(MINIMUM_LATE_CHARGE, 0) MINIMUM_LATE_CHARGE
419: , NVL(MAXIMUM_LATE_CHARGE, 9999999999) MAXIMUM_LATE_CHARGE
420: FROM OKL_LATE_POLICIES_V
421: WHERE NAME = l_id;
422:
423: -- vdamerla: bug 5474844 Get the late charge data
424: