DBA Data[Home] [Help]

APPS.JTF_TTY_NA_WF dependencies on HZ_RELATIONSHIPS

Line 527: from hz_relationships hzr

523: SELECT 'Y'
524: INTO l_chk_done
525: FROM DUAL
526: WHERE EXISTS ( select 'Y'
527: from hz_relationships hzr
528: where hzr.subject_table_name = 'HZ_PARTIES'
529: and hzr.object_table_name = 'HZ_PARTIES'
530: and hzr.relationship_type = 'GLOBAL_ULTIMATE'
531: and hzr.relationship_code = 'GLOBAL_ULTIMATE_OF'

Line 552: from hz_relationships hzr

548: SELECT 'Y'
549: INTO l_chk_done
550: FROM DUAL
551: WHERE EXISTS ( select 'Y'
552: from hz_relationships hzr
553: where hzr.subject_table_name = 'HZ_PARTIES'
554: and hzr.object_table_name = 'HZ_PARTIES'
555: and hzr.relationship_type = 'DOMESTIC_ULTIMATE'
556: and hzr.relationship_code = 'DOMESTIC_ULTIMATE_OF'