APPS.ZX_PTP_MIGRATE_PKG dependencies on DUAL

Line 2225: FROM DUAL

2221: fnd_global.user_id, -- Last_Updated_By
2222: SYSDATE, -- Last_Update_Date
2223: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2224: 1
2225: FROM DUAL
2226: WHERE not exists ( select 1 from zx_party_tax_profile
2227: WHERE party_id = l_org_id and Party_Type_Code = 'OU'));
2228:
2229: ELSE

Line 2392: SELECT '1' from dual

2388: fnd_global.user_id,
2389: SYSDATE,
2390: fnd_global.conc_login_id,
2391: 1)
2392: SELECT '1' from dual
2393: WHERE NOT EXISTS
2394: (SELECT NULL
2395: FROM ZX_FC_TYPES_B TYPE
2396: WHERE TYPE.CLASSIFICATION_TYPE_CODE =

Line 2475: SELECT '1' FROM DUAL

2471: fnd_global.user_id,
2472: SYSDATE,
2473: FND_GLOBAL.CONC_LOGIN_ID,
2474: 1)
2475: SELECT '1' FROM DUAL
2476: WHERE NOT EXISTS
2477: (SELECT NULL
2478: FROM ZX_FC_CODES_B CODES
2479: WHERE CODES.CLASSIFICATION_TYPE_CODE =

Line 2882: FROM DUAL) fc

2878: USING (SELECT
2879: p_party_tax_profile_id party_Tax_profile_id ,
2880: p_fiscal_class_type_code fiscal_class_type_code,
2881: p_fiscal_classification_code fiscal_classification_code
2882: FROM DUAL) fc
2883: ON (pfa.OWNER_TABLE_ID = fc.PARTY_TAX_PROFILE_ID and
2884: pfa.CLASS_CATEGORY = fc.fiscal_class_type_code and
2885: pfa.class_code = fc.fiscal_classification_code)
2886: WHEN MATCHED THEN UPDATE SET