APPS.PV_ATTR_VALIDATION_PUB dependencies on HZ_PARTIES

Line 47: hz_parties pt

43: cursor lc_get_pt_details (pc_partner_id number) is
44: select pt.party_name party_name
45: from hz_relationships pr,
46: hz_organization_profiles op,
47: hz_parties pt
48: where pr.party_id = pc_partner_id
49: and pr.subject_table_name = 'HZ_PARTIES'
50: and pr.object_table_name = 'HZ_PARTIES'
51: and pr.status in ('A', 'I')

Line 49: and pr.subject_table_name = 'HZ_PARTIES'

45: from hz_relationships pr,
46: hz_organization_profiles op,
47: hz_parties pt
48: where pr.party_id = pc_partner_id
49: and pr.subject_table_name = 'HZ_PARTIES'
50: and pr.object_table_name = 'HZ_PARTIES'
51: and pr.status in ('A', 'I')
52: and pr.object_id = op.party_id
53: and op.internal_flag = 'Y'

Line 50: and pr.object_table_name = 'HZ_PARTIES'

46: hz_organization_profiles op,
47: hz_parties pt
48: where pr.party_id = pc_partner_id
49: and pr.subject_table_name = 'HZ_PARTIES'
50: and pr.object_table_name = 'HZ_PARTIES'
51: and pr.status in ('A', 'I')
52: and pr.object_id = op.party_id
53: and op.internal_flag = 'Y'
54: and op.effective_end_date is null

Line 73: hz_parties d

69: select d.party_name
70: from hz_relationships b,
71: hz_relationships c,
72: hz_organization_profiles po,
73: hz_parties d
74: where b.party_id = pc_pt_contact_id
75: and b.subject_table_name = 'HZ_PARTIES'
76: and b.object_table_name = 'HZ_PARTIES'
77: and b.directional_flag = 'F'

Line 75: and b.subject_table_name = 'HZ_PARTIES'

71: hz_relationships c,
72: hz_organization_profiles po,
73: hz_parties d
74: where b.party_id = pc_pt_contact_id
75: and b.subject_table_name = 'HZ_PARTIES'
76: and b.object_table_name = 'HZ_PARTIES'
77: and b.directional_flag = 'F'
78: and b.relationship_code = 'EMPLOYEE_OF'
79: and b.relationship_type = 'EMPLOYMENT'

Line 76: and b.object_table_name = 'HZ_PARTIES'

72: hz_organization_profiles po,
73: hz_parties d
74: where b.party_id = pc_pt_contact_id
75: and b.subject_table_name = 'HZ_PARTIES'
76: and b.object_table_name = 'HZ_PARTIES'
77: and b.directional_flag = 'F'
78: and b.relationship_code = 'EMPLOYEE_OF'
79: and b.relationship_type = 'EMPLOYMENT'
80: and (b.end_date is null or b.end_date > sysdate)

Line 83: and c.subject_table_name = 'HZ_PARTIES'

79: and b.relationship_type = 'EMPLOYMENT'
80: and (b.end_date is null or b.end_date > sysdate)
81: and b.status = 'A'
82: and b.object_id = c.subject_id
83: and c.subject_table_name = 'HZ_PARTIES'
84: and c.object_table_name = 'HZ_PARTIES'
85: and (c.end_date is null or c.end_date > sysdate)
86: and c.status = 'A'
87: and c.object_id = po.party_id

Line 84: and c.object_table_name = 'HZ_PARTIES'

80: and (b.end_date is null or b.end_date > sysdate)
81: and b.status = 'A'
82: and b.object_id = c.subject_id
83: and c.subject_table_name = 'HZ_PARTIES'
84: and c.object_table_name = 'HZ_PARTIES'
85: and (c.end_date is null or c.end_date > sysdate)
86: and c.status = 'A'
87: and c.object_id = po.party_id
88: and d.party_id = b.subject_id