APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 1206: DELETE from pn_payment_terms_all

1202: for the combination of var_rent_inv_id AND rent_TYPE
1203: that are in the draft status since we are recalculating
1204: AND updating the invoice for forecasted rent*/
1205:
1206: DELETE from pn_payment_terms_all
1207: WHERE var_rent_inv_id = l_var_rent_inv_id
1208: AND status <> c_payment_term_status_approved
1209: AND var_rent_TYPE = l_rent_TYPE;
1210:

Line 1497: DELETE from pn_payment_terms_all

1493: null;
1494:
1495: ELSE
1496:
1497: DELETE from pn_payment_terms_all
1498: WHERE status <> c_payment_term_status_approved
1499: AND var_rent_inv_id = rec_get_inv.var_rent_inv_id
1500: AND var_rent_TYPE = decode(g_invoice_on,'ACTUAL','ACTUAL','FORECASTED','VARIANCE');
1501:

Line 1947: FROM pn_payment_terms_all

1943: SELECT 'Y'
1944: INTO l_term_exists
1945: FROM DUAL
1946: WHERE exists ( SELECT null
1947: FROM pn_payment_terms_all
1948: WHERE var_rent_inv_id = p_var_rent_inv_id
1949: AND var_rent_TYPE IN ('ACTUAL', 'VARIANCE'));
1950: ELSE
1951: SELECT 'Y'

Line 1955: FROM pn_payment_terms_all

1951: SELECT 'Y'
1952: INTO l_term_exists
1953: FROM DUAL
1954: WHERE exists ( SELECT null
1955: FROM pn_payment_terms_all
1956: WHERE var_rent_inv_id = p_var_rent_inv_id
1957: AND var_rent_TYPE = p_var_rent_TYPE);
1958: END IF;
1959:

Line 2696: DELETE from pn_payment_terms_all

2692:
2693: IF l_vol_exists = 'N' THEN
2694:
2695: /* Delete from pn_payment_terms if a payment term exists */
2696: DELETE from pn_payment_terms_all
2697: WHERE var_rent_inv_id = l_var_rent_inv_id
2698: AND var_rent_TYPE = l_rent_TYPE
2699: AND status <> c_payment_term_status_approved;
2700: