APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 770: hz_relationship_types typ,

766: hz_parties sub,
767: hz_parties rel,
768: ar_lookups ar,
769: ar_lookups relm,
770: hz_relationship_types typ,
771: hz_code_assignments asg
772: WHERE party_rel.object_id = p_party_id
773: AND party_rel.party_id = rel.party_id
774: AND rel.party_id = p_contact_id

Line 785: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

781: AND party_rel.relationship_code = relm.lookup_code(+)
782: AND nvl(party_rel.start_date, sysdate-1) < sysdate
783: AND nvl(party_rel.end_date , sysdate+1) > sysdate
784: AND party_rel.status = 'A'
785: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
786: AND asg.owner_table_id = typ.relationship_type_id
787: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
788: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
789: AND typ.relationship_type = party_rel.relationship_type

Line 818: hz_relationship_types typ,

814: hz_parties sub,
815: hz_parties rel,
816: ar_lookups ar,
817: ar_lookups relm,
818: hz_relationship_types typ,
819: hz_code_assignments asg
820: WHERE party_rel.object_id = p_party_id
821: AND party_rel.party_id = rel.party_id
822: AND rel.party_id = p_contact_id

Line 832: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

828: AND party_rel.relationship_code = relm.lookup_code(+)
829: AND nvl(party_rel.start_date, sysdate-1) < sysdate
830: AND nvl(party_rel.end_date , sysdate+1) > sysdate
831: AND party_rel.status = 'A'
832: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
833: AND asg.owner_table_id = typ.relationship_type_id
834: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
835: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
836: AND typ.relationship_type = party_rel.relationship_type