APPS.PN_APPROVE_VARENT_PKG dependencies on PN_VAR_DEDUCTIONS_ALL

Line 963: UPDATE pn_var_deductions_all

959: dates that have been transferred only if variable rent term type is actual
960: or variance */
961:
962: IF p_rent_type in ('ACTUAL','VARIANCE') THEN
963: UPDATE pn_var_deductions_all
964: SET exported_code = 'Y',
965: last_update_date = SYSDATE,
966: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
967: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

Line 1005: UPDATE pn_var_deductions_all

1001: (SELECT grp_date_id
1002: FROM pn_var_grp_dates_all
1003: WHERE period_id = p_period_id);
1004:
1005: UPDATE pn_var_deductions_all
1006: SET exported_code = 'Y',
1007: last_update_date = SYSDATE,
1008: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
1009: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)