APPS.PA_CI_IMPACT_TYPE_USAGE_PVT dependencies on DUAL

Line 27: SELECT 'Y' FROM dual

23: )
24: IS
25: l_rowid VARCHAR2(30);
26: CURSOR check_exists is
27: SELECT 'Y' FROM dual
28: WHERE exists (SELECT ci_impact_type_usage_id FROM
29: pa_ci_impact_type_usage
30: WHERE ci_type_class_code = p_ci_type_class_code
31: AND ci_type_id = p_ci_type_id

Line 123: SELECT 'Y' FROM dual

119: )
120: IS
121: l_temp VARCHAR2(1);
122: CURSOR check_exists is
123: SELECT 'Y' FROM dual
124: WHERE exists (SELECT ci_impact_type_usage_id FROM
125: pa_ci_impact_type_usage
126: WHERE ci_impact_type_usage_id = p_ci_impact_type_usage_id
127: );