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 178: ,okl_k_headers_full_v khr

174: ,OKL_CNSLD_AR_HDRS_B HD
175: ,OKC_K_HEADERS_ALL_B CN
176: ,OKL_CNSLD_AR_LINES_B LN
177: ,OKL_STRM_TYPE_B SM
178: ,okl_k_headers_full_v khr
179: ,okc_rule_groups_b rgp
180: ,okc_rules_b rul
181: ,okc_rules_b rul_exm
182: ,okc_rules_b rul_hld

Line 266: ,okl_k_headers_full_v khr

262: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
263: ,okl_bpd_ar_inv_lines_v orig_arl
264: ,okl_bpd_ar_inv_lines_v last_arl
265: ,okl_strm_elements_v sel
266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul
269: ,okc_rules_b rul_exm
270: ,okc_rules_b rul_hld

Line 373: ,okl_k_headers_full_v khr

369: AND LN.ID = ST.LLN_ID
370: AND HD.ID = LN.CNR_ID
371: AND SM.ID = ST.STY_ID) last
372: ,okl_strm_elements_v sel
373: ,okl_k_headers_full_v khr
374: ,okc_rule_groups_b rgp
375: ,okc_rules_b rul
376: ,okc_rules_b rul_exm
377: ,okc_rules_b rul_hld