eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_WF_SYNCH dependencies on HZ_CONTACT_POINTS

Line 522: from hz_contact_points pt, hz_parties

518: -- anonymous block to find the party corresponding to CP
519: BEGIN
520: select owner_table_id, party_type
521: into wf_party_id, wf_party_type
522: from hz_contact_points pt, hz_parties
523: where pt.owner_table_id = party_id and
524: pt.contact_point_type = 'EMAIL' and
525: pt.status ='A' and
526: pt.primary_flag='Y' and

Line 591: from hz_contact_points pt, hz_parties

587: -- anonymous block to find the party corresponding to CP
588: BEGIN
589: select owner_table_id, party_type
590: into wf_party_id, wf_party_type
591: from hz_contact_points pt, hz_parties
592: where pt.owner_table_id = party_id and
593: pt.contact_point_type = 'EMAIL' and
594: pt.owner_table_name ='HZ_PARTIES' and
595: pt.contact_point_id = l_match_string;

Line 799: HZ_CONTACT_POINTS cp,

795: expiration_date,
796: system_id
797: FROM
798: HZ_PARTIES p,
799: HZ_CONTACT_POINTS cp,
800: HZ_PERSON_LANGUAGE pl,
801: FND_LANGUAGES fl
802: WHERE
803: p.party_id = PartyId

Line 992: ,hz_contact_points cp

988: hz_relationships pr
989: ,hz_org_contacts oc
990: ,hz_parties prp -- party relationship party
991: ,hz_parties per
992: ,hz_contact_points cp
993: ,hz_person_language pl
994: ,fnd_languages fl
995: WHERE
996: pr.party_id = c_p_rel_party_id

Line 1271: HZ_CONTACT_POINTS cp,

1267: expiration_date,
1268: system_id
1269: FROM
1270: HZ_PARTIES p,
1271: HZ_CONTACT_POINTS cp,
1272: HZ_PERSON_LANGUAGE pl,
1273: FND_LANGUAGES fl
1274: WHERE
1275: p.party_id = PartyId