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.PV_ASSIGNMENT_PUB dependencies on HZ_RELATIONSHIPS

Line 117: from hz_relationships pr,

113: and lookup_code = pc_assignment_type;
114:
115: cursor lc_get_pt_org_name (pc_partner_id number) is
116: select pt.party_name
117: from hz_relationships pr,
118: hz_organization_profiles op,
119: hz_parties pt
120: where pr.party_id = pc_partner_id
121: and pr.subject_table_name = 'HZ_PARTIES'

Line 169: from hz_relationships emp,

165: cursor lc_get_pt_org_id (pc_user_source_id number) is
166: select emp.object_id pt_org_id,
167: hp.party_name,
168: prof.partner_id
169: from hz_relationships emp,
170: pv_partner_profiles prof,
171: hz_parties hp
172: where emp.party_id = pc_user_source_id
173: and emp.subject_table_name = 'HZ_PARTIES'

Line 1919: from hz_relationships pr,

1915: and lookup_code = pc_reason_code;
1916:
1917: cursor lc_get_pt_org_name (pc_partner_id number) is
1918: select pt.party_name
1919: from hz_relationships pr,
1920: hz_organization_profiles op,
1921: hz_parties pt
1922: where pr.party_id = pc_partner_id
1923: and pr.subject_table_name = 'HZ_PARTIES'

Line 2887: from hz_relationships emp,hz_parties hp

2883:
2884: CURSOR lc_get_ven_pty_name(pc_source_id NUMBER)
2885: IS
2886: select hp.party_name
2887: from hz_relationships emp,hz_parties hp
2888: where emp.party_id = pc_source_id
2889: and emp.subject_table_name = 'HZ_PARTIES'
2890: and emp.object_table_name = 'HZ_PARTIES'
2891: and emp.directional_flag = 'F'

Line 3450: hz_relationships emp,

3446: fu.user_id,
3447: re.resource_id
3448: from fnd_user fu,
3449: jtf_rs_resource_extns re,
3450: hz_relationships emp,
3451: pv_partner_profiles pt,
3452: pv_lead_assignments la
3453: where fu.user_name = pc_user_name
3454: and fu.user_id = re.user_id

Line 3471: from hz_relationships pr,

3467: and la.status in (g_la_status_pt_approved, g_la_status_cm_app_for_pt);
3468:
3469: cursor lc_get_pt_org_name (pc_partner_id number) is
3470: select pt.party_name
3471: from hz_relationships pr,
3472: hz_organization_profiles op,
3473: hz_parties pt
3474: where pr.party_id = pc_partner_id
3475: and pr.subject_table_name = 'HZ_PARTIES'

Line 3537: from hz_relationships emp,hz_parties hp

3533:
3534: CURSOR lc_get_ven_pty_name(pc_source_id NUMBER)
3535: IS
3536: select hp.party_name
3537: from hz_relationships emp,hz_parties hp
3538: where emp.party_id = pc_source_id
3539: and emp.subject_table_name = 'HZ_PARTIES'
3540: and emp.object_table_name = 'HZ_PARTIES'
3541: and emp.directional_flag = 'F'