DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_RELATIONSHIPS

Line 743: FROM hz_relationships party_rel,

739:
740: CURSOR c_contact_org(p_party_id in number,
741: p_contact_id in number) IS
742: SELECT rel.party_id
743: FROM hz_relationships party_rel,
744: hz_parties sub,
745: hz_parties rel,
746: ar_lookups ar,
747: ar_lookups relm,

Line 776: FROM hz_relationships party_rel,

772: AND party_rel.relationship_code = typ.forward_rel_code;
773:
774: CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
775: SELECT rel.party_id
776: FROM hz_relationships party_rel,
777: hz_parties sub,
778: hz_parties rel,
779: ar_lookups ar,
780: ar_lookups relm,