DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_K_HEADERS_FULL_V

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

37: l_amount NUMBER;
38: l_interest_amount NUMBER;
39:
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;

Line 42: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;

38: l_interest_amount NUMBER;
39:
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:

Line 43: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;

39:
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;

Line 51: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;

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;
50:
51: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
52: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
53: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
54:
55: l_last_updated_by NUMBER;

Line 52: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%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;
50:
51: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
52: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
53: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
54:
55: l_last_updated_by NUMBER;
56: l_last_update_login NUMBER;

Line 53: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;

49: l_late_int_minimum_balance okl_late_policies_b.late_int_minimum_balance%TYPE;
50:
51: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
52: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
53: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
54:
55: l_last_updated_by NUMBER;
56: l_last_update_login NUMBER;
57: l_request_id NUMBER;

Line 128: , OKL_K_HEADERS_FULL_V KHR

124: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
125: ,max('AR-INVOICE') invoice_flag
126: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
127: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
128: , OKL_K_HEADERS_FULL_V KHR
129: , OKC_RULE_GROUPS_B RGP
130: , OKC_RULES_B RUL
131: , okc_rules_b rul_exm
132: ,okc_rules_b rul_hld

Line 201: , OKL_K_HEADERS_FULL_V KHR

197: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
198: ,max('AR-INVOICE') invoice_flag
199: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
200: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
201: , OKL_K_HEADERS_FULL_V KHR
202: , OKC_RULE_GROUPS_B RGP
203: , OKC_RULES_B RUL
204: , okc_rules_b rul_exm
205: ,okc_rules_b rul_hld

Line 287: , OKL_K_HEADERS_FULL_V KHR

283: , max('CONS-INVOICE') invoice_flag
284: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
285: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
286: , OKL_CNSLD_AR_STRMS_B CNSLD
287: , OKL_K_HEADERS_FULL_V KHR
288: , OKC_RULE_GROUPS_B RGP
289: , OKC_RULES_B RUL
290: , okc_rules_b rul_exm
291: ,okc_rules_b rul_hld