eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VAR_ABATEMENTS_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 414: FROM pn_var_grp_dates_all gd1,

410:
411: /*Cursor to get all invoices*/
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

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 442: FROM pn_var_grp_dates_all gd

438: vrent.lease_id = pterm.lease_id
439: AND vrent.var_rent_id = vinv.var_rent_id
440: AND pterm.start_date <=
441: (SELECT MAX(gd.grp_end_date)
442: FROM pn_var_grp_dates_all gd
443: WHERE gd.period_id = vinv.period_id
444: AND gd.invoice_date = vinv.invoice_date
445: )
446: AND pterm.end_date >=

Line 448: FROM pn_var_grp_dates_all gd1

444: AND gd.invoice_date = vinv.invoice_date
445: )
446: AND pterm.end_date >=
447: (SELECT MIN(gd1.grp_start_date)
448: FROM pn_var_grp_dates_all gd1
449: WHERE gd1.period_id = vinv.period_id
450: AND gd1.invoice_date = vinv.invoice_date
451: )
452: AND pterm.var_rent_inv_id IS NULL

Line 704: FROM pn_var_grp_dates_all gd1,

700:
701: /*Cursor to get all invoices from 2nd annual period*/
702: CURSOR get_all_inv(p_var_rent_id IN NUMBER) IS
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

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 734: FROM pn_var_grp_dates_all gd

730: vrent.lease_id = pterm.lease_id
731: AND vrent.var_rent_id = vinv.var_rent_id
732: AND pterm.start_date <=
733: (SELECT MAX(gd.grp_end_date)
734: FROM pn_var_grp_dates_all gd
735: WHERE gd.period_id = vinv.period_id
736: AND gd.invoice_date = vinv.invoice_date
737: )
738: AND pterm.end_date >=

Line 740: FROM pn_var_grp_dates_all gd1

736: AND gd.invoice_date = vinv.invoice_date
737: )
738: AND pterm.end_date >=
739: (SELECT MIN(gd1.grp_start_date)
740: FROM pn_var_grp_dates_all gd1
741: WHERE gd1.period_id = vinv.period_id
742: AND gd1.invoice_date = vinv.invoice_date
743: )
744: AND pterm.var_rent_inv_id IS NULL