[Home] [Help]
14: -- approve_payment_term_batch, CURSOR csr_get_inv for
15: -- Mass Calculate Variable Rent
16: -- 09-Jan-03 DThota o Changed p_period_date to VARCHAR2 from DATE in
17: -- approve_payment_term_batch and put in
18: -- fnd_date.canonical_to_date before p_period_date in
19: -- the WHERE clause of CURSOR csr_get_inv. Bug#2733870
20: -- 14-JUL-05 HRodda o Bug 4284035 - Replaced pn_leases with _ALL table.
21: -- 26-Oct-06 Shabda o Modified cursor csr_get_inv to accomodate true_up invoices
22: -- 27-Oct-06 Shabda o Modified cursor csr_get_inv to accomodate adjustment terms
117: AND inv.actual_exp_code = decode(ip_rent_type,'ACTUAL','N',inv.actual_exp_code)
118: AND inv.variance_exp_code = decode(ip_rent_type,'VARIANCE','N',inv.variance_exp_code)
119: AND inv.var_rent_inv_id = NVL(p_var_rent_inv_id,inv.var_rent_inv_id)
120: AND ip_rent_type = NVL(ip_var_rent_type,ip_rent_type)
121: AND invoice_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
122: UNION
123: SELECT per.period_num,
124: inv.var_rent_inv_id,
125: inv.adjust_num,
146: AND inv.variance_exp_code = decode(ip_rent_type,'VARIANCE','N',inv.variance_exp_code)
147: AND pmt.var_rent_inv_id = inv.var_rent_inv_id
148: AND pmt.status = 'APPROVED'
149: AND ip_rent_type = NVL(ip_var_rent_type,ip_rent_type)
150: AND invoice_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
151: )temp
152: ORDER BY period_num,invoice_date;
153:
154: