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 794: HZ_CONTACT_POINTS cp,

790: expiration_date,
791: system_id
792: FROM
793: HZ_PARTIES p,
794: HZ_CONTACT_POINTS cp,
795: HZ_PERSON_LANGUAGE pl,
796: FND_LANGUAGES fl
797: WHERE
798: p.party_id = PartyId

Line 987: ,hz_contact_points cp

983: hz_relationships pr
984: ,hz_org_contacts oc
985: ,hz_parties prp -- party relationship party
986: ,hz_parties per
987: ,hz_contact_points cp
988: ,hz_person_language pl
989: ,fnd_languages fl
990: WHERE
991: pr.party_id = c_p_rel_party_id

Line 1246: HZ_CONTACT_POINTS cp,

1242: expiration_date,
1243: system_id
1244: FROM
1245: HZ_PARTIES p,
1246: HZ_CONTACT_POINTS cp,
1247: HZ_PERSON_LANGUAGE pl,
1248: FND_LANGUAGES fl
1249: WHERE
1250: p.party_id = PartyId