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_REC_CALC_PKG dependencies on PN_REC_ARCL_ALL

Line 2504: ,pn_rec_arcl_all aclass

2500: ,area_class_dtl_hdr.area_class_dtl_id
2501: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2502: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2503: ,pn_rec_agr_linarea_all linearea
2504: ,pn_rec_arcl_all aclass
2505: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2506: AND p_as_of_date between linearea.start_date and linearea.end_date
2507: AND linearea.area_class_id = aclass.area_class_id
2508: AND area_class_dtl_hdr.area_class_id = aclass.area_class_id

Line 2651: ,pn_rec_arcl_all aclass

2647: INTO l_ten_recoverable_area_rec
2648: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2649: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2650: ,pn_rec_agr_linarea_all linearea
2651: ,pn_rec_arcl_all aclass
2652: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2653: AND p_as_of_date between linearea.start_date and linearea.end_date
2654: AND linearea.area_class_id = aclass.area_class_id
2655: AND area_class_dtl_hdr.area_class_id = aclass.area_class_id

Line 2763: ,pn_rec_arcl_all aclass

2759: (SELECT area_class_dtl_hdr.area_class_dtl_id
2760: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2761: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2762: ,pn_rec_agr_linarea_all linearea
2763: ,pn_rec_arcl_all aclass
2764: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2765: AND p_as_of_date between linearea.start_date
2766: and linearea.end_date
2767: AND linearea.area_class_id = aclass.area_class_id

Line 2846: ,pn_rec_arcl_all aclass

2842: (SELECT area_class_dtl_hdr.area_class_dtl_id
2843: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2844: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2845: ,pn_rec_agr_linarea_all linearea
2846: ,pn_rec_arcl_all aclass
2847: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2848: AND p_as_of_date between linearea.start_date
2849: and linearea.end_date
2850: AND linearea.area_class_id = aclass.area_class_id

Line 5217: ,pn_rec_arcl_all aclass

5213: area_class_dtl_hdr.area_class_dtl_id as area_class_dtl_id
5214: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
5215: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
5216: ,pn_rec_agr_linarea_all linearea
5217: ,pn_rec_arcl_all aclass
5218: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
5219: AND p_as_of_date between linearea.start_date and linearea.end_date
5220: AND aclass.area_class_id = linearea.area_class_id
5221: AND area_class_dtl_hdr.area_class_id = aclass.area_class_id