APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_PERIODS_ALL

Line 58: pn_var_periods_all per

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

Line 90: pn_var_periods_all per

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

Line 1232: FROM pn_var_periods_all

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

Line 1515: FROM pn_var_periods_all

1511:
1512: -- Get the period_id
1513: CURSOR period_cur IS
1514: SELECT period_id
1515: FROM pn_var_periods_all
1516: WHERE var_rent_id = p_vr_id
1517: AND p_date BETWEEN start_date AND end_date;
1518:
1519: l_prd_id NUMBER:=NULL;

Line 1697: FROM pn_var_periods_all

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