APPS.PN_VAR_ABATEMENTS_PKG dependencies on DUAL

Line 61: FROM dual;

57:
58: IF ( X_VAR_ABATEMENT_ID IS NULL) THEN
59: SELECT pn_var_abatements_s.nextval
60: INTO X_VAR_ABATEMENT_ID
61: FROM dual;
62: END IF;
63:
64: INSERT INTO PN_VAR_ABATEMENTS_ALL
65: ( VAR_RENT_ID,

Line 267: FROM dual WHERE EXISTS

263: -- Get calculated invoices after this invoice
264: CURSOR calc_inv_exists(p1_inv_date IN DATE,p1_var_rent_id IN NUMBER)
265: IS
266: SELECT 'Y' calc_inv
267: FROM dual WHERE EXISTS
268: (SELECT *
269: FROM pn_var_rent_inv_all
270: WHERE var_rent_id=p1_var_rent_id
271: AND invoice_date > p1_inv_date);

Line 314: FROM dual

310: p_var_rent_inv_id IN NUMBER,
311: p_pmt_term_id IN NUMBER)
312: IS
313: SELECT 'y'
314: FROM dual
315: WHERE exists ( select null from pn_var_abatements_all
316: where var_rent_id=p_var_rentId AND
317: var_rent_inv_id=p_var_rent_inv_id AND
318: payment_term_id=p_pmt_term_id);

Line 432: FROM dual WHERE EXISTS

428:
429: /*Cursor to check if a pmt term exists for a particular invoice*/
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

Line 461: FROM dual

457:
458: /*Cursor to check if an abtmt exists for a particular invoice*/
459: CURSOR check_abtmt_terms_inv(p_inv_id IN NUMBER,p_term_id IN NUMBER) IS
460: SELECT 'x' abatement_exists
461: FROM dual
462: WHERE EXISTS (SELECT payment_term_id
463: FROM pn_var_abatements_all
464: WHERE var_rent_inv_id=p_inv_id
465: AND payment_term_id=p_term_id);

Line 724: FROM dual WHERE EXISTS

720:
721: /*Cursor to check if a pmt term exists for a particular invoice*/
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

Line 753: FROM dual

749:
750: /*Cursor to check if an abtmt exists for a particular invoice*/
751: CURSOR check_abtmt_terms_inv(p_inv_id IN NUMBER,p_term_id IN NUMBER) IS
752: SELECT 'x' abatement_exists
753: FROM dual
754: WHERE exists (select payment_term_id
755: FROM pn_var_abatements_all
756: WHERE var_rent_inv_id=p_inv_id
757: AND payment_term_id=p_term_id);

Line 893: FROM dual

889: -- Get the details of
890: CURSOR get_true_up_cur
891: IS
892: SELECT 'Y' as true_up_flag
893: FROM dual
894: WHERE EXISTS(SELECT NULL
895: FROM pn_var_rent_inv_all
896: WHERE var_rent_inv_id = p_var_rent_inv_id
897: AND true_up_amt IS NOT NULL