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: ,okl_strm_type_b stb --For bug 7356486
127: where lpt.invoice_id=lpt1.invoice_id
128: and lpt.pay_sch_class = 'INV'
129: AND lpt.STATUS = 'OP'

Line 183: ,okl_late_policies_v lte

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

Line 271: ,okl_late_policies_v lte

267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul
269: ,okc_rules_b rul_exm
270: ,okc_rules_b rul_hld
271: ,okl_late_policies_v lte
272: WHERE last_arl.sel_id = sel.id
273: and orig_arv.pay_sch_class = 'INV'
274: AND orig_arv.STATUS = 'OP'
275: and orig_arl.receivables_invoice_id = sel.source_id

Line 378: ,okl_late_policies_v lte

374: ,okc_rule_groups_b rgp
375: ,okc_rules_b rul
376: ,okc_rules_b rul_exm
377: ,okc_rules_b rul_hld
378: ,okl_late_policies_v lte
379: where last.sel_id = sel.id
380: and orig.class = 'INV'
381: and orig.status = 'OP'
382: and orig.consolidated_invoice_id = sel.source_id

Line 425: FROM OKL_LATE_POLICIES_V

421: , NVL(LATE_CHRG_GRACE_PERIOD,0) LATE_CHRG_GRACE_PERIOD
422: , NVL(LATE_CHRG_MINIMUM_BALANCE, 0) LATE_CHRG_MINIMUM_BALANCE
423: , NVL(MINIMUM_LATE_CHARGE, 0) MINIMUM_LATE_CHARGE
424: , NVL(MAXIMUM_LATE_CHARGE, 9999999999) MAXIMUM_LATE_CHARGE
425: FROM OKL_LATE_POLICIES_V
426: WHERE NAME = l_id;
427:
428: -- vdamerla: bug 5474844 Get the late charge data
429: