APPS.PN_APPROVE_VARENT_PKG dependencies on PN_VAR_PERIODS_ALL

Line 107: pn_var_periods_all per

103: inv.actual_invoiced_amount,
104: decode(ip_rent_type,'FORECASTED',inv.forecasted_term_status,'ACTUAL',inv.actual_term_status,
105: 'VARIANCE',inv.variance_term_status) term_status
106: FROM pn_var_rent_inv_all inv,
107: pn_var_periods_all per
108: WHERE per.var_rent_id = inv.var_rent_id
109: AND per.period_id = inv.period_id
110: AND inv.var_rent_id = ip_var_rent_id
111: AND per.period_num >= NVL(p_period_num_from,per.period_num)

Line 134: pn_var_periods_all per,

130: inv.actual_invoiced_amount,
131: decode(ip_rent_type,'FORECASTED',inv.forecasted_term_status,'ACTUAL',inv.actual_term_status,
132: 'VARIANCE',inv.variance_term_status) term_status
133: FROM pn_var_rent_inv_all inv,
134: pn_var_periods_all per,
135: pn_payment_terms_all pmt
136: WHERE per.var_rent_id = inv.var_rent_id
137: AND per.period_id = inv.period_id
138: AND inv.var_rent_id = ip_var_rent_id

Line 473: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

469: -- Get the details of
470: CURSOR period_FY_cur(p_period_id NUMBER,
471: p_var_rent_id NUMBER) IS
472: SELECT period_id
473: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
474: WHERE pvr.var_rent_id = pvp.var_rent_id
475: AND pvp.period_id = p_period_id
476: AND pvr.var_rent_id = p_var_rent_id
477: AND pvr.proration_rule IN ('FLY', 'FY')