APPS.PN_APPROVE_VARENT_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 106: FROM pn_var_rent_inv_all inv,

102: inv.for_per_rent,
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

Line 133: FROM pn_var_rent_inv_all inv,

129: inv.for_per_rent,
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

Line 899: UPDATE pn_var_rent_inv_all

895: actual_exp_code to 'Y' if p_rent_type is 'ACTUAL' and variance_exp_code to
896: 'Y' if p_rent_type is 'VARIANCE' in pn_var_grp_dates and pn_var_vol_hist
897: to 'Y'
898: */
899: UPDATE pn_var_rent_inv_all
900: SET forecasted_exp_code = DECODE(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
901: actual_exp_code = DECODE(p_rent_type,'ACTUAL','Y',actual_exp_code),
902: variance_exp_code = DECODE(p_rent_type,'VARIANCE','Y',variance_exp_code),
903: last_update_date = SYSDATE,

Line 909: UPDATE pn_var_rent_inv_all

905: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
906: WHERE var_rent_inv_id = p_var_rent_inv_id;
907:
908: /* pinky */
909: UPDATE pn_var_rent_inv_all
910: SET true_up_exp_code = 'Y'
911: WHERE var_rent_inv_id = p_var_rent_inv_id
912: AND true_up_exp_code IS NOT NULL;
913: /* pinky */