DBA Data[Home] [Help]

APPS.PN_VAR_TRUEUP_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 587: pn_payment_terms_all

583: IF (round(l_total_period_rent, l_precision) - round(l_prev_inv_trueup_rent, l_precision)) <> round(l_curr_inv_trueup_rent, l_precision)
584: THEN
585:
586: DELETE
587: pn_payment_terms_all
588: WHERE
589: var_rent_inv_id = l_var_rent_inv_id AND
590: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED;
591:

Line 942: pn_payment_terms_all

938: IF (l_is_inv_exp = 'N' ) AND
939: (round(l_abated_rent,l_precision) - round(l_prev_inv_exp,l_precision))<> NVL(l_actual_invoiced_amount, 0) THEN
940:
941: DELETE
942: pn_payment_terms_all
943: WHERE
944: var_rent_inv_id = inv_rec.var_rent_inv_id AND
945: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
946: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;