APPS.PN_VAR_ABATEMENTS_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 260: FROM pn_var_rent_inv_all

256: -- Get the invoice date
257: CURSOR get_inv_date(p1_var_rent_inv_id IN NUMBER)
258: IS
259: SELECT invoice_date
260: FROM pn_var_rent_inv_all
261: WHERE var_rent_inv_id=p1_var_rent_inv_id;
262:
263: -- Get calculated invoices after this invoice
264: CURSOR calc_inv_exists(p1_inv_date IN DATE,p1_var_rent_id IN NUMBER)

Line 269: FROM pn_var_rent_inv_all

265: IS
266: SELECT 'Y' calc_inv
267: FROM dual WHERE EXISTS
268: (SELECT *
269: FROM pn_var_rent_inv_all
270: WHERE var_rent_id=p1_var_rent_id
271: AND invoice_date > p1_inv_date);
272:
273: l_inv_date DATE := NULL;

Line 408: FROM pn_var_rent_inv_all

404:
405: -- Get invoice date
406: CURSOR get_inv_dt(p_var_rent_inv_id IN NUMBER) IS
407: SELECT invoice_date
408: FROM pn_var_rent_inv_all
409: WHERE var_rent_inv_id=p_var_rent_inv_id;
410:
411: /*Cursor to get all invoices*/
412: CURSOR get_all_inv(p_var_rent_id IN NUMBER,l_invoice_dt IN DATE) IS

Line 416: FROM pn_var_grp_dates_all gd , pn_var_rent_inv_all vinv

412: CURSOR get_all_inv(p_var_rent_id IN NUMBER,l_invoice_dt IN DATE) IS
413: SELECT distinct gd1.invoice_date,decode(temp.inv_id,NULL,-1,temp.inv_id) v_inv_id
414: FROM pn_var_grp_dates_all gd1,
415: (SELECT gd.invoice_date inv_dt,vinv.var_rent_inv_id inv_id
416: FROM pn_var_grp_dates_all gd , pn_var_rent_inv_all vinv
417: WHERE vinv.var_rent_id=gd.var_rent_id
418: AND vinv.invoice_date=gd.invoice_date
419: AND vinv.period_id=gd.period_id
420: AND gd.var_rent_id=p_var_rent_id

Line 436: pn_var_rent_inv_all vinv

432: FROM dual WHERE EXISTS
433: (SELECT NULL
434: FROM pn_payment_terms_all pterm,
435: pn_var_rents_all vrent,
436: pn_var_rent_inv_all vinv
437: WHERE
438: vrent.lease_id = pterm.lease_id
439: AND vrent.var_rent_id = vinv.var_rent_id
440: AND pterm.start_date <=

Line 707: FROM pn_var_grp_dates_all gd , pn_var_rent_inv_all vinv

703: SELECT distinct gd1.invoice_date,decode(temp.inv_id,NULL,-1,temp.inv_id) v_inv_id
704: FROM pn_var_grp_dates_all gd1,
705: pn_var_periods_all vp,
706: (SELECT gd.invoice_date inv_dt,vinv.var_rent_inv_id inv_id
707: FROM pn_var_grp_dates_all gd , pn_var_rent_inv_all vinv
708: WHERE vinv.var_rent_id=gd.var_rent_id
709: AND vinv.invoice_date=gd.invoice_date
710: AND vinv.period_id=gd.period_id
711: AND gd.var_rent_id=p_var_rent_id

Line 728: pn_var_rent_inv_all vinv

724: FROM dual WHERE EXISTS
725: (SELECT NULL
726: FROM pn_payment_terms_all pterm,
727: pn_var_rents_all vrent,
728: pn_var_rent_inv_all vinv
729: WHERE
730: vrent.lease_id = pterm.lease_id
731: AND vrent.var_rent_id = vinv.var_rent_id
732: AND pterm.start_date <=

Line 895: FROM pn_var_rent_inv_all

891: IS
892: SELECT 'Y' as true_up_flag
893: FROM dual
894: WHERE EXISTS(SELECT NULL
895: FROM pn_var_rent_inv_all
896: WHERE var_rent_inv_id = p_var_rent_inv_id
897: AND true_up_amt IS NOT NULL
898: );
899: l_true_up_flag VARCHAR2(1) := 'N';