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_DTLLN_ALL

Line 855: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%TYPE:=0;

851: l_fee_before_contr pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE :=0;
852: l_fee_after_contr pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE :=0;
853: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
854: l_ten_recoverable_area_rec ten_recoverable_area_rec;
855: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%TYPE:=0;
856: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%TYPE:=0;
857: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE:=0;
858: l_line_constraints pn_rec_agr_linconst_all.value%TYPE:=0;
859: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE:=0;

Line 856: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%TYPE:=0;

852: l_fee_after_contr pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE :=0;
853: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
854: l_ten_recoverable_area_rec ten_recoverable_area_rec;
855: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%TYPE:=0;
856: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%TYPE:=0;
857: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE:=0;
858: l_line_constraints pn_rec_agr_linconst_all.value%TYPE:=0;
859: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE:=0;
860: l_ten_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;

Line 2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;

2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;

2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2490: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

Line 2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2490: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2491: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2490: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2491: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2492: l_context VARCHAR2(2000):= null;

Line 2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2490: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2491: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2492: l_context VARCHAR2(2000):= null;
2493:

Line 2491: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2490: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2491: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2492: l_context VARCHAR2(2000):= null;
2493:
2494: cursor c_area is
2495: SELECT area_class_dtl_hdr.TOTAL_assignable_area

Line 2501: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2497: ,nvl(area_class_dtl_hdr.TOTAL_WEIGHTED_AVG_ovr, area_class_dtl_hdr.TOTAL_WEIGHTED_AVG)
2498: ,linearea.FLOOR_PCT
2499: ,linearea.area_type
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

Line 2548: FROM pn_rec_arcl_dtlln_all area_class_dtl

2544: INTO
2545: l_asgn_area_contr,
2546: l_occp_area_contr,
2547: l_wgt_avg_area_contr
2548: FROM pn_rec_arcl_dtlln_all area_class_dtl
2549: --WHERE area_class_dtl_line_id = l_area_class_dtl_id
2550: -- Fix for bug#9579092, l_area_class_dtl_id is wrongly compared with area_class_dtl_line_id
2551: WHERE area_class_dtl_id = l_area_class_dtl_id
2552: AND exclude_area_ovr_flag = 'Y'

Line 2648: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2644:
2645: SELECT nvl(area_class_dtl_lines.occupied_area_ovr, area_class_dtl_lines.occupied_area)
2646: ,occupancy_pct
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

Line 2757: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2753: (
2754: SELECT area_class_dtl_lines.location_id,
2755: area_class_dtl_lines.cust_account_id,
2756: area_class_dtl_lines.lease_id
2757: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2758: WHERE area_class_dtl_id =
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

Line 2760: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2756: area_class_dtl_lines.lease_id
2757: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2758: WHERE area_class_dtl_id =
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

Line 2840: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2836: (
2837: SELECT area_class_dtl_lines.location_id,
2838: area_class_dtl_lines.cust_account_id,
2839: area_class_dtl_lines.lease_id
2840: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2841: WHERE area_class_dtl_id =
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

Line 2843: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2839: area_class_dtl_lines.lease_id
2840: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2841: WHERE area_class_dtl_id =
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

Line 5214: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

5210: p_location_id number
5211: ) is
5212: SELECT
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