DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_RELATIONSHIPS

Line 765: FROM hz_relationships party_rel,

761:
762: CURSOR c_contact_org(p_party_id in number,
763: p_contact_id in number) IS
764: SELECT rel.party_id
765: FROM hz_relationships party_rel,
766: hz_parties sub,
767: hz_parties rel,
768: ar_lookups ar,
769: ar_lookups relm,

Line 800: Hz_Relationships r

796:
797: CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
798: SELECT sub.party_id
799: FROM Hz_Parties sub,
800: Hz_Relationships r
801: WHERE r.object_id = p_party_id
802: AND r.party_id = p_contact_id
803: AND sub.status = 'A'
804: AND r.status = 'A'

Line 813: FROM hz_relationships party_rel,

809:
810:
811: /*CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
812: SELECT rel.party_id
813: FROM hz_relationships party_rel,
814: hz_parties sub,
815: hz_parties rel,
816: ar_lookups ar,
817: ar_lookups relm,