DBA Data[Home] [Help]

APPS.FUN_TCA_PKG dependencies on HZ_RELATIONSHIPS

Line 73: FROM hz_relationships hzr

69: ELSE
70: -- hzr has time component in start and end dates
71: SELECT hzr.object_id
72: INTO l_le_id
73: FROM hz_relationships hzr
74: WHERE HZR.subject_id=p_party_id
75: AND hzr.subject_table_name='HZ_PARTIES'
76: AND hzr.object_table_name='HZ_PARTIES'
77: AND hzr.relationship_code='INTERCOMPANY_ORGANIZATION_OF'

Line 100: FROM hz_relationships hzr

96: RETURN NUMBER is
97: l_ou_id NUMBER;
98: BEGIN
99: SELECT hzr.subject_id into l_ou_id
100: FROM hz_relationships hzr
101: WHERE HZR.object_id=p_party_id
102: AND hzr.subject_table_name='HR_ALL_ORGANIZATION_UNITS'
103: AND hzr.object_table_name='HZ_PARTIES'
104: AND hzr.relationship_type='INTERCOMPANY_OPERATING_UNIT'