DBA Data[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_VAR_RENTS_ALL

Line 7157: FROM pn_var_rents_all pvr

7153: /* -- CURSORS -- */
7154:
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

Line 8223: FROM pn_var_rents_all

8219:
8220: CURSOR var_cur(p1_lease_id IN NUMBER)
8221: IS
8222: SELECT var_rent_id
8223: FROM pn_var_rents_all
8224: WHERE lease_id = p1_lease_id;
8225:
8226: CURSOR terms_cur (p1_lease_id IN NUMBER)
8227: IS