APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_PERIODS_ALL

Line 61: pn_var_periods_all per

57: FROM pn_leases pl,
58: pn_lease_details_all pld,
59: pn_var_rents_all pvr,
60: pn_locations_all ploc,
61: pn_var_periods_all per
62: WHERE pl.lease_id = pvr.lease_id
63: AND pld.lease_id = pvr.lease_id
64: AND ploc.location_id = pvr.location_id
65: AND pvr.var_rent_id = per.var_rent_id

Line 93: pn_var_periods_all per

89: pl.org_id
90: FROM pn_var_rents_all pvr,
91: pn_leases pl,
92: pn_lease_details_all pld,
93: pn_var_periods_all per
94: WHERE pl.lease_id = pvr.lease_id
95: AND pld.lease_id = pvr.lease_id
96: AND pvr.var_rent_id = per.var_rent_id
97: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)

Line 1236: FROM pn_var_periods_all

1232:
1233: -- Get partial period information
1234: CURSOR partial_prd(p_vr_id IN NUMBER) IS
1235: SELECT period_id, period_num, start_date, end_date
1236: FROM pn_var_periods_all
1237: WHERE partial_period='Y'
1238: AND var_rent_id = p_vr_id;
1239:
1240: -- Get invoice period dates

Line 1519: FROM pn_var_periods_all

1515:
1516: -- Get the period_id
1517: CURSOR period_cur IS
1518: SELECT period_id
1519: FROM pn_var_periods_all
1520: WHERE var_rent_id = p_vr_id
1521: AND p_date BETWEEN start_date AND end_date;
1522:
1523: l_prd_id NUMBER:=NULL;

Line 1701: FROM pn_var_periods_all

1697:
1698: -- Get partial period information
1699: CURSOR partial_prd(p_vr_id IN NUMBER) IS
1700: SELECT period_id, period_num, start_date, end_date
1701: FROM pn_var_periods_all
1702: WHERE partial_period='Y'
1703: AND var_rent_id = p_vr_id;
1704:
1705: -- Get invoice period dates