DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_VAR_RENT_INV_ALL

Line 8407: pn_var_rent_inv_all pvri,

8403: /* Get all abatements lines that will go bad with the new term dates */
8404: CURSOR chk_abat_retro IS
8405: SELECT pvr.rent_num
8406: FROM pn_var_rents_all pvr,
8407: pn_var_rent_inv_all pvri,
8408: pn_var_abatements_all pva
8409: WHERE pva.payment_term_id = p_term_id
8410: AND pvri.var_rent_inv_id = pva.var_rent_inv_id
8411: AND pvri.invoice_date NOT BETWEEN p_new_start_date