DBA Data[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_VAR_ABATEMENTS_ALL

Line 7159: ,pn_var_abatements_all pva

7155: CURSOR get_vr_cur(p_term_id IN NUMBER) IS
7156: SELECT pvr.rent_num
7157: FROM pn_var_rents_all pvr
7158: ,pn_var_rent_inv_all pvri
7159: ,pn_var_abatements_all pva
7160: ,pn_payment_terms_all ppt
7161: WHERE ppt.payment_term_id = p_term_id
7162: AND pva.payment_term_id = ppt.payment_term_id
7163: AND pvri.var_rent_inv_id = pva.var_rent_inv_id