APPS.PN_VAR_ABATEMENTS_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 36: FROM pn_payment_terms_all

32: WHERE VAR_ABATEMENT_ID = X_VAR_ABATEMENT_ID;
33:
34: CURSOR org_cur IS
35: SELECT org_id
36: FROM pn_payment_terms_all
37: WHERE payment_term_id = x_payment_term_id;
38:
39: l_org_id NUMBER;
40:

Line 434: FROM pn_payment_terms_all pterm,

430: CURSOR check_pmt_terms(p_inv_id IN NUMBER,p_term_id IN NUMBER) IS
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

Line 726: FROM pn_payment_terms_all pterm,

722: CURSOR check_pmt_terms(p_inv_id IN NUMBER,p_term_id IN NUMBER) IS
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