DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_VAR_ABATEMENTS_ALL

Line 8576: pn_var_abatements_all pva

8572: CURSOR chk_abat_retro IS
8573: SELECT pvr.rent_num
8574: FROM pn_var_rents_all pvr,
8575: pn_var_rent_inv_all pvri,
8576: pn_var_abatements_all pva
8577: WHERE pva.payment_term_id = p_term_id
8578: AND pvri.var_rent_inv_id = pva.var_rent_inv_id
8579: AND pvri.invoice_date NOT BETWEEN p_new_start_date
8580: AND p_new_end_date