DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on HZ_RELATIONSHIPS

Line 2441: -- relaced hz_party_relationships with hz_relationships

2437: AND sysdate between nvl(per.effective_start_date, sysdate)
2438: and nvl(per.effective_end_date, sysdate);
2439:
2440: -- bug # 6630754
2441: -- relaced hz_party_relationships with hz_relationships
2442: cursor c_REL_contact(v_id number) is
2443: SELECT
2444: hp.person_first_name ||' '|| hp.person_last_name contactname,
2445: hp.email_address email

Line 2447: hz_relationships rel,

2443: SELECT
2444: hp.person_first_name ||' '|| hp.person_last_name contactname,
2445: hp.email_address email
2446: FROM
2447: hz_relationships rel,
2448: hz_parties hp
2449: WHERE
2450: rel.party_id = v_id
2451: AND rel.subject_id = hp.party_id