APPS.FUN_TCA_PKG dependencies on HZ_PARTIES

Line 75: AND hzr.subject_table_name='HZ_PARTIES'

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'
78: AND hzr.relationship_type='INTERCOMPANY_LEGAL_ENTITY'
79: AND hzr.directional_flag='F'

Line 76: AND hzr.object_table_name='HZ_PARTIES'

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'
78: AND hzr.relationship_type='INTERCOMPANY_LEGAL_ENTITY'
79: AND hzr.directional_flag='F'
80: AND hzr.status='A'

Line 103: AND hzr.object_table_name='HZ_PARTIES'

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'
105: AND hzr.relationship_code='OPERATING_UNIT_OF'
106: AND hzr.directional_flag='B'
107: AND hzr.status='A'

Line 131: FROM hz_parties

127: l_sys_ref VARCHAR2(240);
128: BEGIN
129: SELECT orig_system_reference
130: INTO l_sys_ref
131: FROM hz_parties
132: WHERE party_id = p_party_id;
133: RETURN l_sys_ref;
134: EXCEPTION
135: WHEN OTHERS THEN

Line 151: FROM hz_parties

147: l_status VARCHAR2(10);
148: BEGIN
149: SELECT status
150: INTO l_status
151: FROM hz_parties
152: WHERE party_id=p_party_id;
153: IF(l_status <>'A') THEN RETURN 'N';
154: END IF;
155:

Line 168: AND hca.owner_table_name='HZ_PARTIES' ;

164: FROM HZ_CODE_ASSIGNMENTS hca
165: WHERE hca.owner_table_id=p_party_id
166: AND hca.class_category='INTERCOMPANY'
167: AND hca.class_code ='INTERCOMPANY'
168: AND hca.owner_table_name='HZ_PARTIES' ;
169: */
170: IF(l_status = 'A') THEN RETURN 'Y';
171: ELSE RETURN 'N';
172: END IF;

Line 188: FROM hz_parties

184: l_status VARCHAR2(10);
185: BEGIN
186: SELECT status
187: INTO l_status
188: FROM hz_parties
189: WHERE party_id=p_party_id;
190: IF(l_status <>'A') THEN RETURN 'N';
191: END IF;
192:

Line 207: AND hca.owner_table_name='HZ_PARTIES'

203: FROM HZ_CODE_ASSIGNMENTS hca
204: WHERE hca.owner_table_id=p_party_id
205: AND hca.class_category='INTERCOMPANY'
206: AND hca.class_code ='INTERCOMPANY'
207: AND hca.owner_table_name='HZ_PARTIES'
208: AND start_date_active<=nvl(p_as_date ,sysdate)
209: AND (end_date_active >= nvl(p_as_date ,sysdate) OR end_date_active IS NULL);
210: */
211: IF(l_status = 'A') THEN RETURN 'Y';

Line 259: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';

255: BEGIN
256:
257: --- Classifying Legal Entity as Intercompany
258: /*
259: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
260: l_code_assignment_rec.owner_table_id := p_party_id;
261: l_code_assignment_rec.class_category := 'INTERCOMPANY';
262: l_code_assignment_rec.class_code := 'INTERCOMPANY';
263: l_code_assignment_rec.primary_flag := 'Y';

Line 307: FROM hz_parties h, hz_party_usg_assignments hua

303: IS
304:
305: CURSOR chk_party IS
306: SELECT 'Y'
307: FROM hz_parties h, hz_party_usg_assignments hua
308: WHERE h.party_name = l_party_name
309: AND hua.party_id = h.party_id
310: AND hua.party_usage_code = 'INTERCOMPANY_ORG';
311: BEGIN