APPS.PN_VAR_ABATEMENTS_PKG dependencies on PN_VAR_RENTS_ALL

Line 435: pn_var_rents_all vrent,

431: SELECT 'x' pterm_exists
432: FROM dual WHERE EXISTS
433: (SELECT NULL
434: FROM pn_payment_terms_all pterm,
435: pn_var_rents_all vrent,
436: pn_var_rent_inv_all vinv
437: WHERE
438: vrent.lease_id = pterm.lease_id
439: AND vrent.var_rent_id = vinv.var_rent_id

Line 477: FROM pn_var_rents_all

473: AND update_flag = 'Y';
474:
475: CURSOR org_cur(p_var_rentId IN NUMBER) IS
476: SELECT org_id
477: FROM pn_var_rents_all
478: WHERE var_rent_id =p_var_rentId;
479:
480: l_org_id NUMBER;
481:

Line 727: pn_var_rents_all vrent,

723: SELECT 'x' pterm_exists
724: FROM dual WHERE EXISTS
725: (SELECT NULL
726: FROM pn_payment_terms_all pterm,
727: pn_var_rents_all vrent,
728: pn_var_rent_inv_all vinv
729: WHERE
730: vrent.lease_id = pterm.lease_id
731: AND vrent.var_rent_id = vinv.var_rent_id

Line 769: FROM pn_var_rents_all

765: AND update_flag = 'Y';
766:
767: CURSOR org_cur(p_var_rentId IN NUMBER) IS
768: SELECT org_id
769: FROM pn_var_rents_all
770: WHERE var_rent_id =p_var_rentId;
771:
772: l_org_id NUMBER;
773: