DBA Data[Home] [Help]

APPS.OKL_LTE_CHRG_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

46: l_sec_rec_inv_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;
47: l_error_flag BOOLEAN := FALSE;
48:
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;

Line 51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;

47: l_error_flag BOOLEAN := FALSE;
48:
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:

Line 52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;

48:
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:

Line 67: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%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;
68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
70:
71: l_last_updated_by NUMBER;

Line 68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_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;
68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
70:
71: l_last_updated_by NUMBER;
72: l_last_update_login NUMBER;

Line 69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;

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;
68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
70:
71: l_last_updated_by NUMBER;
72: l_last_update_login NUMBER;
73: l_request_id NUMBER;

Line 120: ,okl_k_headers_full_v khr

116: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
117: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
118: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) lpt
119: ,okl_bpd_ar_inv_lines_v lpt1
120: ,okl_k_headers_full_v khr
121: ,okc_rule_groups_b rgp
122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm
124: ,okc_rules_b rul_hld

Line 174: ,okl_k_headers_full_v khr

170: ,OKL_CNSLD_AR_HDRS_B HD
171: ,OKC_K_HEADERS_ALL_B CN
172: ,OKL_CNSLD_AR_LINES_B LN
173: ,OKL_STRM_TYPE_B SM
174: ,okl_k_headers_full_v khr
175: ,okc_rule_groups_b rgp
176: ,okc_rules_b rul
177: ,okc_rules_b rul_exm
178: ,okc_rules_b rul_hld

Line 261: ,okl_k_headers_full_v khr

257: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
258: ,okl_bpd_ar_inv_lines_v orig_arl
259: ,okl_bpd_ar_inv_lines_v last_arl
260: ,okl_strm_elements_v sel
261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul
264: ,okc_rules_b rul_exm
265: ,okc_rules_b rul_hld

Line 368: ,okl_k_headers_full_v khr

364: AND LN.ID = ST.LLN_ID
365: AND HD.ID = LN.CNR_ID
366: AND SM.ID = ST.STY_ID) last
367: ,okl_strm_elements_v sel
368: ,okl_k_headers_full_v khr
369: ,okc_rule_groups_b rgp
370: ,okc_rules_b rul
371: ,okc_rules_b rul_exm
372: ,okc_rules_b rul_hld