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 795: HZ_PERSON_LANGUAGE pl,

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

Line 988: ,hz_person_language pl

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

Line 1247: HZ_PERSON_LANGUAGE pl,

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