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.CAC_VIEW_PVT dependencies on HZ_PARTIES

Line 754: hz_parties party,

750: jtf_task_statuses_tl task_status,
751: jtf_task_statuses_vl assign_status,
752: jtf_task_types_tl task_type,
753: jtf_task_priorities_tl task_priority,
754: hz_parties party,
755: hz_party_sites site,
756: hz_locations location,
757: jtf_rs_resource_extns owner,
758: jtf_task_all_assignments assignment,

Line 2391: From hz_parties per, hz_relationships hr

2387: IS
2388: person_party_name varchar2(25);
2389: BEGIN
2390: Select per.party_name into person_party_name
2391: From hz_parties per, hz_relationships hr
2392: Where hr.subject_table_name = 'HZ_PARTIES'
2393: and hr.object_table_name = 'HZ_PARTIES'
2394: and hr.directional_flag = 'F'
2395: and hr.subject_id = per.party_id

Line 2392: Where hr.subject_table_name = 'HZ_PARTIES'

2388: person_party_name varchar2(25);
2389: BEGIN
2390: Select per.party_name into person_party_name
2391: From hz_parties per, hz_relationships hr
2392: Where hr.subject_table_name = 'HZ_PARTIES'
2393: and hr.object_table_name = 'HZ_PARTIES'
2394: and hr.directional_flag = 'F'
2395: and hr.subject_id = per.party_id
2396: and per.party_type = 'PERSON'

Line 2393: and hr.object_table_name = 'HZ_PARTIES'

2389: BEGIN
2390: Select per.party_name into person_party_name
2391: From hz_parties per, hz_relationships hr
2392: Where hr.subject_table_name = 'HZ_PARTIES'
2393: and hr.object_table_name = 'HZ_PARTIES'
2394: and hr.directional_flag = 'F'
2395: and hr.subject_id = per.party_id
2396: and per.party_type = 'PERSON'
2397: and hr.party_id = p_party_id;