APPS.ZX_PARTY_MERGE_PKG dependencies on DUAL

Line 1543: FROM dual;

1539: FOR rec IN get_from_ptp_registrations LOOP
1540:
1541: SELECT zx_registrations_s.nextval
1542: INTO l_registration_id
1543: FROM dual;
1544:
1545: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2
1546: INSERT INTO ZX_REGISTRATIONS
1547: (registration_type_code

Line 1661: FROM DUAL

1657: ,1
1658: ,rec.rounding_level_code
1659: ,rec.account_type_code
1660: ,TO_NUMBER(NULL)
1661: FROM DUAL
1662: WHERE NOT EXISTS
1663: (SELECT 1
1664: FROM zx_registrations ref_data
1665: WHERE ref_data.party_tax_profile_id = p_to_ptp_id