APPS.HZ_RELATIONSHIP_TYPES_PKG dependencies on DUAL

Line 98: FROM dual

94: ELSE
95: BEGIN
96: /* Bug Fix:4176951 */
97: SELECT 'Y' INTO l_do_not_allow_convert
98: FROM dual
99: WHERE EXISTS (
100: SELECT 'Y'
101: FROM hz_relationship_types
102: WHERE relationship_type = X_RELATIONSHIP_TYPE

Line 132: INTO X_RELATIONSHIP_TYPE_ID FROM dual;

128: BEGIN
129: l_count := 1;
130: WHILE l_count > 0 LOOP
131: SELECT HZ_RELATIONSHIP_TYPES_S.NEXTVAL
132: INTO X_RELATIONSHIP_TYPE_ID FROM dual;
133: BEGIN
134: SELECT 'Y' INTO l_dummy
135: FROM HZ_RELATIONSHIP_TYPES
136: WHERE RELATIONSHIP_TYPE_ID = X_RELATIONSHIP_TYPE_ID;