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.

[Home] [Help]

APPS.PN_REC_CALC_PKG dependencies on PN_REC_ARCL_ALL

Line 2473: ,pn_rec_arcl_all aclass

2469: ,area_class_dtl_hdr.area_class_dtl_id
2470: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2471: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2472: ,pn_rec_agr_linarea_all linearea
2473: ,pn_rec_arcl_all aclass
2474: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2475: AND p_as_of_date between linearea.start_date and linearea.end_date
2476: AND linearea.area_class_id = aclass.area_class_id
2477: AND area_class_dtl_hdr.area_class_id = aclass.area_class_id

Line 2617: ,pn_rec_arcl_all aclass

2613: INTO l_ten_recoverable_area_rec
2614: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2615: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2616: ,pn_rec_agr_linarea_all linearea
2617: ,pn_rec_arcl_all aclass
2618: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2619: AND p_as_of_date between linearea.start_date and linearea.end_date
2620: AND linearea.area_class_id = aclass.area_class_id
2621: AND area_class_dtl_hdr.area_class_id = aclass.area_class_id

Line 2729: ,pn_rec_arcl_all aclass

2725: (SELECT area_class_dtl_hdr.area_class_dtl_id
2726: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2727: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2728: ,pn_rec_agr_linarea_all linearea
2729: ,pn_rec_arcl_all aclass
2730: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2731: AND p_as_of_date between linearea.start_date
2732: and linearea.end_date
2733: AND linearea.area_class_id = aclass.area_class_id

Line 2812: ,pn_rec_arcl_all aclass

2808: (SELECT area_class_dtl_hdr.area_class_dtl_id
2809: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2810: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2811: ,pn_rec_agr_linarea_all linearea
2812: ,pn_rec_arcl_all aclass
2813: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2814: AND p_as_of_date between linearea.start_date
2815: and linearea.end_date
2816: AND linearea.area_class_id = aclass.area_class_id

Line 5132: ,pn_rec_arcl_all aclass

5128: area_class_dtl_hdr.area_class_dtl_id as area_class_dtl_id
5129: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
5130: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
5131: ,pn_rec_agr_linarea_all linearea
5132: ,pn_rec_arcl_all aclass
5133: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
5134: AND p_as_of_date between linearea.start_date and linearea.end_date
5135: AND aclass.area_class_id = linearea.area_class_id
5136: AND area_class_dtl_hdr.area_class_id = aclass.area_class_id