APPS.LNS_FINANCIALS dependencies on DUAL

Line 284: from dual;

280: ,index_rate = null
281: where rate_id = p_rate_id;
282:
283: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_new_rate_id
284: from dual;
285:
286: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - adding new row into rate schedule');
287: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_new_rate_id ' || l_new_rate_id );
288: insert into lns_rate_schedules(RATE_ID

Line 7784: || p_ending_balance => future or residual value of the loan (most loans will pass 0)

7780: || PARAMETERS
7781: ||
7782: || Parameter: p_loan_amount => amount of loan
7783: || p_num_intervals => number of installments for loan
7784: || p_ending_balance => future or residual value of the loan (most loans will pass 0)
7785: || p_pay_in_arrears => true if payments are at end of period
7786: || false otherwise
7787: ||
7788: || payment = (p_loan_amount - p_ending_balance) / p_num_intervals;

Line 7851: || p_ending_balance => future or residual value of the loan (most loans will pass 0)

7847: ||
7848: || Parameter: p_annualized_rate => annual rate of the loan
7849: || p_loan_amount => amount of loan
7850: || p_num_intervals => number of installments for loan
7851: || p_ending_balance => future or residual value of the loan (most loans will pass 0)
7852: || p_pay_in_arrears => true if payments are at end of period
7853: || false otherwise
7854: ||
7855: || payment =

Line 8663: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;

8659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': compounds per year: ' || l_compounds_per_year);
8660:
8661: if (p_period_start_date is not null and p_period_end_date is not null) then
8662:
8663: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
8664: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
8665:
8666: l_days_ratio := 0;
8667:

Line 8664: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;

8660:
8661: if (p_period_start_date is not null and p_period_end_date is not null) then
8662:
8663: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
8664: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
8665:
8666: l_days_ratio := 0;
8667:
8668: for k in l_year1..l_year2 loop

Line 8786: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;

8782:
8783: l_annual_rate := p_annualized_rate / 100;
8784: l_periodic_rate := 0;
8785:
8786: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
8787: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
8788:
8789: for k in l_year1..l_year2 loop
8790:

Line 8787: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;

8783: l_annual_rate := p_annualized_rate / 100;
8784: l_periodic_rate := 0;
8785:
8786: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
8787: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
8788:
8789: for k in l_year1..l_year2 loop
8790:
8791: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ------ calculating for year ' || k);