DBA Data[Home] [Help]

APPS.JTF_TTY_NA_TERRGP dependencies on HZ_RELATIONSHIPS

Line 61: FROM hz_relationships hzr

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'

Line 86: FROM hz_relationships hzr

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'