[Home] [Help]
12: -- CURSOR csr_act_inv,CURSOR csr_var_inv.
13: -- 09-Jan-03 dthota o Changed p_period_date to VARCHAR2 from DATE in
14: -- create_payment_term_batch,CURSOR csr_for_inv,
15: -- CURSOR csr_act_inv,CURSOR csr_var_inv and added
16: -- fnd_date.canonical_to_date before p_period_date
17: -- in the WHERE clauses of the cursors.
18: -- Fix for bug # 2733870
19: -- 21-Oct-04 vmmehta o Bug# 3942264. Added code to reset term_status if term
20: -- creation fails for actual/forecasted/variance terms.
120: AND nvl(for_per_rent,0) <> 0
121: AND forecasted_exp_code = 'N'
122: AND forecasted_term_status = decode(p_period_id,null,'N','Y')
123: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'FORECASTED') ='N'
124: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
125: ORDER BY invoice_date;
126:
127: /* Get the actual rent amounts */
128:
140: AND actual_exp_code = 'N'
141: AND nvl(actual_invoiced_amount,0) <> 0
142: AND actual_term_status = decode(p_period_id,null,'N','Y')
143: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'ACTUAL') ='N'
144: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
145: ORDER BY invoice_date;
146:
147: /* get the actual-forecasted rent amounts */
148:
167: AND gd.period_id = inv.period_id
168: AND gd.var_rent_id = inv.var_rent_id
169: AND nvl(gd.forecasted_exp_code,'N') = 'N')
170: AND pn_variable_amount_pkg.find_if_term_exists(inv.var_rent_inv_id,'VARIANCE') = 'N'
171: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
172: ORDER BY inv.invoice_date;
173:
174: CURSOR payment_cur(p_invoice_date DATE,p_var_rent_id NUMBER) IS
175: SELECT payment_term_id