DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on HZ_RELATIONSHIPS

Line 2451: -- relaced hz_party_relationships with hz_relationships

2447: AND sysdate between nvl(per.effective_start_date, sysdate)
2448: and nvl(per.effective_end_date, sysdate);
2449:
2450: -- bug # 6630754
2451: -- relaced hz_party_relationships with hz_relationships
2452: cursor c_REL_contact(v_id number) is
2453: SELECT
2454: hp.person_first_name ||' '|| hp.person_last_name contactname,
2455: hp.email_address email

Line 2457: hz_relationships rel,

2453: SELECT
2454: hp.person_first_name ||' '|| hp.person_last_name contactname,
2455: hp.email_address email
2456: FROM
2457: hz_relationships rel,
2458: hz_parties hp
2459: WHERE
2460: rel.party_id = v_id
2461: AND rel.subject_id = hp.party_id