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_PERSON_LANGUAGE

Line 248: from hz_parties p, hz_person_language l

244: -- anonymous block to find the person corresponding to language
245: BEGIN
246: select p.party_id, party_type
247: into wf_party_id, wf_party_type
248: from hz_parties p, hz_person_language l
249: where p.party_id= l.party_id and
250: primary_language_indicator='Y' and
251: l.status ='A' and
252: language_use_reference_id = wf_lang_user_ref_id;

Line 323: from hz_parties p, hz_person_language l

319: -- anonymous block to find the person corresponding to language
320: BEGIN
321: select p.party_id, party_type
322: into wf_party_id, wf_party_type
323: from hz_parties p, hz_person_language l
324: where p.party_id= l.party_id and
325: -- primary_language_indicator='Y' and
326: -- l.status ='A' and
327: language_use_reference_id = wf_lang_user_ref_id;

Line 800: HZ_PERSON_LANGUAGE pl,

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
804: AND p.party_type = 'PERSON'

Line 993: ,hz_person_language pl

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
997: AND pr.subject_table_name = 'HZ_PARTIES'

Line 1272: HZ_PERSON_LANGUAGE pl,

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
1276: AND p.party_type = 'GROUP'