APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_PERIODS_ALL

Line 244: FROM pn_var_periods_all per,

240: CURSOR csr_get_lines(ip_line_item_id NUMBER) IS
241: SELECT lines.line_item_num,
242: lines.period_id,
243: lines.line_item_id
244: FROM pn_var_periods_all per,
245: pn_var_lines_all lines
246: WHERE lines.period_id= per.period_id
247: AND per.var_rent_id = p_var_rent_id
248: AND per.period_id = p_period_id

Line 2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp

2070:
2071:
2072: CURSOR first_period_cur IS
2073: SELECT pvp.period_id
2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp
2075: WHERE pvr.var_rent_id = p_var_rent_id
2076: AND pvr.var_rent_id = pvp.var_rent_id
2077: AND proration_rule IN ('FY', 'FLY')
2078: AND pvp.start_date = pvr.commencement_date;

Line 2345: FROM pn_var_periods_all

2341: SELECT period_id,
2342: period_num,
2343: start_date,
2344: end_date
2345: FROM pn_var_periods_all
2346: WHERE var_rent_id = ip_var_rent_id
2347: AND period_id = NVL(p_period_id,period_id)
2348: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
2349: AND period_num >= NVL(p_period_num_from,period_num)