APPS.PN_OPEX_TERMS_PKG dependencies on DUAL

Line 1671: null) INTO working_date FROM DUAL;

1667: 'RS' , recon_rec.period_start_dt ,
1668: 'RE' , recon_rec.period_end_dt ,
1669: 'CS' , TO_DATE('01-01-'||TO_CHAR(recon_rec.period_end_dt,'YYYY'),'DD-MM-YYYY'),
1670: 'ST' , recon_rec.st_recv_dt ,
1671: null) INTO working_date FROM DUAL;
1672: IF working_date IS NULL THEN
1673: RETURN NULL ;
1674: END IF;
1675:

Line 1688: , null) INTO working_date from dual;

1684: 'D' , working_date + -NVL(st_due_rec.time_unit,0),
1685: 'Y' , ADD_MONTHS(working_date , -NVL(st_due_rec.time_unit,0) * 12),
1686: 'W' , working_date + -NVL(st_due_rec.time_unit,0)*7,
1687: null) -- default
1688: , null) INTO working_date from dual;
1689:
1690: EXCEPTION
1691: WHEN NO_DATA_FOUND THEN
1692: RETURN NULL;

Line 1727: FROM DUAL WHERE EXISTS

1723: BEGIN
1724: x_return_status := 'S';
1725: BEGIN
1726: SELECT 'N' INTO l_deletion_allowed
1727: FROM DUAL WHERE EXISTS
1728: (SELECT payment_term_id
1729: FROM pn_payment_terms_all
1730: WHERE opex_agr_id = p_agreement_id
1731: AND status = 'APPROVED');