57: SELECT 'Y'
58: INTO l_chk_done
59: FROM DUAL
60: WHERE EXISTS ( SELECT 'Y'
61: FROM hz_relationships hzr
62: WHERE hzr.subject_table_name = 'HZ_PARTIES'
63: AND hzr.object_table_name = 'HZ_PARTIES'
64: AND hzr.relationship_type = 'GLOBAL_ULTIMATE'
65: AND hzr.relationship_code = 'GLOBAL_ULTIMATE_OF'
82: SELECT 'Y'
83: INTO l_chk_done
84: FROM DUAL
85: WHERE EXISTS ( SELECT 'Y'
86: FROM hz_relationships hzr
87: WHERE hzr.subject_table_name = 'HZ_PARTIES'
88: AND hzr.object_table_name = 'HZ_PARTIES'
89: AND hzr.relationship_type = 'DOMESTIC_ULTIMATE'
90: AND hzr.relationship_code = 'DOMESTIC_ULTIMATE_OF'