APPS.PN_APPROVE_VARENT_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 926: UPDATE pn_var_vol_hist_all

922: WHERE period_id = p_period_id
923: AND invoice_date = p_invoice_date
924: AND var_rent_id = p_var_rent_id;
925:
926: UPDATE pn_var_vol_hist_all
927: SET forecasted_exp_code = decode(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
928: last_update_date = SYSDATE,
929: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
930: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

Line 942: UPDATE pn_var_vol_hist_all

938: AND var_rent_id = p_var_rent_id);
939:
940:
941:
942: UPDATE pn_var_vol_hist_all
943: SET actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
944: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
945: last_update_date = SYSDATE,
946: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

Line 991: UPDATE pn_var_vol_hist_all

987: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
988: WHERE period_id = p_period_id
989: AND var_rent_id = p_var_rent_id;
990:
991: UPDATE pn_var_vol_hist_all
992: SET actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
993: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
994: last_update_date = SYSDATE,
995: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),