APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_PERIODS

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 182: l_period_id pn_var_periods.period_id%type;

178:
179:
180: l_rent_num pn_var_rents.rent_num%type;
181: l_invoice_on pn_var_rents.invoice_on%type;
182: l_period_id pn_var_periods.period_id%type;
183: l_period_num pn_var_periods.period_num%type;
184: l_lease_id pn_var_rents.lease_id%type;
185: l_location_id pn_var_rents.location_id%type;
186: l_var_rent_id pn_var_rents.var_rent_id%type;

Line 183: l_period_num pn_var_periods.period_num%type;

179:
180: l_rent_num pn_var_rents.rent_num%type;
181: l_invoice_on pn_var_rents.invoice_on%type;
182: l_period_id pn_var_periods.period_id%type;
183: l_period_num pn_var_periods.period_num%type;
184: l_lease_id pn_var_rents.lease_id%type;
185: l_location_id pn_var_rents.location_id%type;
186: l_var_rent_id pn_var_rents.var_rent_id%type;
187: l_pre_var_rent_id pn_var_rents.var_rent_id%type;

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