APPS.PN_OPEX_TERMS_PKG dependencies on DUAL

Line 1700: null) INTO working_date FROM DUAL;

1696: 'RS' , recon_rec.period_start_dt ,
1697: 'RE' , recon_rec.period_end_dt ,
1698: 'CS' , TO_DATE('01-01-'||TO_CHAR(recon_rec.period_end_dt,'YYYY'),'DD-MM-YYYY'),
1699: 'ST' , recon_rec.st_recv_dt ,
1700: null) INTO working_date FROM DUAL;
1701: IF working_date IS NULL THEN
1702: RETURN NULL ;
1703: END IF;
1704:

Line 1717: , null) INTO working_date from dual;

1713: 'D' , working_date + -NVL(st_due_rec.time_unit,0),
1714: 'Y' , ADD_MONTHS(working_date , -NVL(st_due_rec.time_unit,0) * 12),
1715: 'W' , working_date + -NVL(st_due_rec.time_unit,0)*7,
1716: null) -- default
1717: , null) INTO working_date from dual;
1718:
1719: EXCEPTION
1720: WHEN NO_DATA_FOUND THEN
1721: RETURN NULL;

Line 1756: FROM DUAL WHERE EXISTS

1752: BEGIN
1753: x_return_status := 'S';
1754: BEGIN
1755: SELECT 'N' INTO l_deletion_allowed
1756: FROM DUAL WHERE EXISTS
1757: (SELECT payment_term_id
1758: FROM pn_payment_terms_all
1759: WHERE opex_agr_id = p_agreement_id
1760: AND status = 'APPROVED');