APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 748: hz_relationship_types typ,

744: hz_parties sub,
745: hz_parties rel,
746: ar_lookups ar,
747: ar_lookups relm,
748: hz_relationship_types typ,
749: hz_code_assignments asg
750: WHERE party_rel.object_id = p_party_id
751: AND party_rel.party_id = rel.party_id
752: AND rel.party_id = p_contact_id

Line 763: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

759: AND party_rel.relationship_code = relm.lookup_code(+)
760: AND nvl(party_rel.start_date, sysdate-1) < sysdate
761: AND nvl(party_rel.end_date , sysdate+1) > sysdate
762: AND party_rel.status = 'A'
763: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
764: AND asg.owner_table_id = typ.relationship_type_id
765: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
766: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
767: AND typ.relationship_type = party_rel.relationship_type

Line 781: hz_relationship_types typ,

777: hz_parties sub,
778: hz_parties rel,
779: ar_lookups ar,
780: ar_lookups relm,
781: hz_relationship_types typ,
782: hz_code_assignments asg
783: WHERE party_rel.object_id = p_party_id
784: AND party_rel.party_id = rel.party_id
785: AND rel.party_id = p_contact_id

Line 795: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

791: AND party_rel.relationship_code = relm.lookup_code(+)
792: AND nvl(party_rel.start_date, sysdate-1) < sysdate
793: AND nvl(party_rel.end_date , sysdate+1) > sysdate
794: AND party_rel.status = 'A'
795: AND asg.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
796: AND asg.owner_table_id = typ.relationship_type_id
797: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
798: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
799: AND typ.relationship_type = party_rel.relationship_type