APPS.ZX_PTP_MIGRATE_PKG dependencies on DUAL

Line 2345: FROM DUAL

2341: fnd_global.user_id, -- Last_Updated_By
2342: SYSDATE, -- Last_Update_Date
2343: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2344: 1
2345: FROM DUAL
2346: WHERE not exists ( select 1 from zx_party_tax_profile
2347: WHERE party_id = l_org_id and Party_Type_Code = 'OU'));
2348:
2349: ELSE

Line 2512: SELECT '1' from dual

2508: fnd_global.user_id,
2509: SYSDATE,
2510: fnd_global.conc_login_id,
2511: 1)
2512: SELECT '1' from dual
2513: WHERE NOT EXISTS
2514: (SELECT NULL
2515: FROM ZX_FC_TYPES_B TYPE
2516: WHERE TYPE.CLASSIFICATION_TYPE_CODE =

Line 2595: SELECT '1' FROM DUAL

2591: fnd_global.user_id,
2592: SYSDATE,
2593: FND_GLOBAL.CONC_LOGIN_ID,
2594: 1)
2595: SELECT '1' FROM DUAL
2596: WHERE NOT EXISTS
2597: (SELECT NULL
2598: FROM ZX_FC_CODES_B CODES
2599: WHERE CODES.CLASSIFICATION_TYPE_CODE =

Line 3002: FROM DUAL) fc

2998: USING (SELECT
2999: p_party_tax_profile_id party_Tax_profile_id ,
3000: p_fiscal_class_type_code fiscal_class_type_code,
3001: p_fiscal_classification_code fiscal_classification_code
3002: FROM DUAL) fc
3003: ON (pfa.OWNER_TABLE_ID = fc.PARTY_TAX_PROFILE_ID and
3004: pfa.CLASS_CATEGORY = fc.fiscal_class_type_code and
3005: pfa.class_code = fc.fiscal_classification_code)
3006: WHEN MATCHED THEN UPDATE SET