DBA Data[Home] [Help]

APPS.GCS_ICM_INTG_PROF_PKG dependencies on DUAL

Line 35: USING (SELECT 1 FROM DUAL) src

31: FROM fnd_profile_options
32: WHERE profile_option_name = p_option_name;
33:
34: MERGE INTO fnd_profile_option_values pov
35: USING (SELECT 1 FROM DUAL) src
36: ON (pov.application_id = l_application_id AND
37: pov.profile_option_id = l_profile_option_id AND
38: pov.level_id = 10001)
39: WHEN MATCHED THEN

Line 173: 'FROM DUAL'

169: l_run_id NUMBER;
170: BEGIN
171: EXECUTE IMMEDIATE
172: 'SELECT amw_fin_stmnt_selection_s.nextval ' ||
173: 'FROM DUAL'
174: INTO l_run_id;
175:
176: EXECUTE IMMEDIATE
177: 'INSERT INTO amw_fin_stmnt_selection ' ||