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_ASSIGN_UTIL_PVT dependencies on HZ_PARTIES

Line 1071: b.subject_table_name = 'HZ_PARTIES' and

1067: fnd_user usr
1068: where
1069: a.partner_id = pc_partner_id and
1070: a.partner_party_id = b.object_id and
1071: b.subject_table_name = 'HZ_PARTIES' and
1072: b.object_table_name = 'HZ_PARTIES' and
1073: b.directional_flag = 'F' and
1074: b.relationship_code = 'EMPLOYEE_OF' and
1075: b.relationship_type = 'EMPLOYMENT' and

Line 1072: b.object_table_name = 'HZ_PARTIES' and

1068: where
1069: a.partner_id = pc_partner_id and
1070: a.partner_party_id = b.object_id and
1071: b.subject_table_name = 'HZ_PARTIES' and
1072: b.object_table_name = 'HZ_PARTIES' and
1073: b.directional_flag = 'F' and
1074: b.relationship_code = 'EMPLOYEE_OF' and
1075: b.relationship_type = 'EMPLOYMENT' and
1076: (b.end_date is null or b.end_date > sysdate) and

Line 1098: and pr2.subject_table_name = 'HZ_PARTIES'

1094: fnd_user usr
1095: WHERE
1096: prof.partner_id = pc_partner_id
1097: and prof.partner_party_id = pr2.object_id
1098: and pr2.subject_table_name = 'HZ_PARTIES'
1099: and pr2.object_table_name = 'HZ_PARTIES'
1100: and pr2.directional_flag = 'F'
1101: and pr2.relationship_code = 'EMPLOYEE_OF'
1102: and pr2.relationship_type = 'EMPLOYMENT'

Line 1099: and pr2.object_table_name = 'HZ_PARTIES'

1095: WHERE
1096: prof.partner_id = pc_partner_id
1097: and prof.partner_party_id = pr2.object_id
1098: and pr2.subject_table_name = 'HZ_PARTIES'
1099: and pr2.object_table_name = 'HZ_PARTIES'
1100: and pr2.directional_flag = 'F'
1101: and pr2.relationship_code = 'EMPLOYEE_OF'
1102: and pr2.relationship_type = 'EMPLOYMENT'
1103: and (pr2.end_date is null or pr2.end_date > sysdate)

Line 1136: hz_parties pt,

1132: from pv_partner_profiles pf,
1133: hz_relationships pr,
1134: hz_organization_profiles op,
1135: ar_lookups ar,
1136: hz_parties pt,
1137: (select distinct a.partner_id, 'Y' indirectly_managed_flag from pv_partner_accesses a, pv_partner_profiles b
1138: where a.partner_id = pc_party_rel_id
1139: and a.vad_partner_id = b.partner_id and b.status = 'A') imp
1140: where pf.partner_id = pc_party_rel_id

Line 1143: and pr.subject_table_name = 'HZ_PARTIES'

1139: and a.vad_partner_id = b.partner_id and b.status = 'A') imp
1140: where pf.partner_id = pc_party_rel_id
1141: and pf.partner_id = imp.partner_id (+)
1142: and pr.party_id = pf.partner_id
1143: and pr.subject_table_name = 'HZ_PARTIES'
1144: and pr.object_table_name = 'HZ_PARTIES'
1145: and (pr.end_date is null or pr.end_date > sysdate)
1146: and pr.status in ('A', 'I')
1147: and pr.object_id = op.party_id

Line 1144: and pr.object_table_name = 'HZ_PARTIES'

1140: where pf.partner_id = pc_party_rel_id
1141: and pf.partner_id = imp.partner_id (+)
1142: and pr.party_id = pf.partner_id
1143: and pr.subject_table_name = 'HZ_PARTIES'
1144: and pr.object_table_name = 'HZ_PARTIES'
1145: and (pr.end_date is null or pr.end_date > sysdate)
1146: and pr.status in ('A', 'I')
1147: and pr.object_id = op.party_id
1148: and op.internal_flag = 'Y'

Line 1175: emp.subject_table_name = 'HZ_PARTIES' and

1171: PT_PROF.status = 'A' and
1172: PT_ACC.resource_id = extn.resource_id and
1173: extn.category = pv_assignment_pub.g_resource_party and
1174: extn.source_id = emp.party_id and
1175: emp.subject_table_name = 'HZ_PARTIES' and
1176: emp.object_table_name = 'HZ_PARTIES' and
1177: emp.directional_flag = 'F' and
1178: emp.relationship_code = 'EMPLOYEE_OF' and
1179: emp.relationship_type = 'EMPLOYMENT' and

Line 1176: emp.object_table_name = 'HZ_PARTIES' and

1172: PT_ACC.resource_id = extn.resource_id and
1173: extn.category = pv_assignment_pub.g_resource_party and
1174: extn.source_id = emp.party_id and
1175: emp.subject_table_name = 'HZ_PARTIES' and
1176: emp.object_table_name = 'HZ_PARTIES' and
1177: emp.directional_flag = 'F' and
1178: emp.relationship_code = 'EMPLOYEE_OF' and
1179: emp.relationship_type = 'EMPLOYMENT' and
1180: (emp.end_date is null or emp.end_date > sysdate) and

Line 1786: FROM hz_parties PARTNER, hz_relationships HZR_PART_CONT, hz_org_contacts ORG_CONTACT,

1782: pc_salesforce_id number
1783: ) is
1784:
1785: SELECT pvpp.partner_id
1786: FROM hz_parties PARTNER, hz_relationships HZR_PART_CONT, hz_org_contacts ORG_CONTACT,
1787: hz_contact_points hcp, pv_partner_profiles pvpp, jtf_rs_resource_extns res
1788: WHERE
1789: PARTNER.PARTY_ID = pvpp.partner_party_id and
1790: PARTNER.party_type = 'ORGANIZATION' AND

Line 1793: HZR_PART_CONT.subject_table_name = 'HZ_PARTIES' AND

1789: PARTNER.PARTY_ID = pvpp.partner_party_id and
1790: PARTNER.party_type = 'ORGANIZATION' AND
1791: HZR_PART_CONT.object_id = PARTNER.PARTY_ID AND
1792: HZR_PART_CONT.relationship_type = 'EMPLOYMENT' AND
1793: HZR_PART_CONT.subject_table_name = 'HZ_PARTIES' AND
1794: HZR_PART_CONT.object_table_name = 'HZ_PARTIES' AND
1795: HZR_PART_CONT.PARTY_ID = res.source_id and
1796: res.resource_id = pc_salesforce_id and
1797: HZR_PART_CONT.relationship_id = ORG_CONTACT.party_relationship_id AND

Line 1794: HZR_PART_CONT.object_table_name = 'HZ_PARTIES' AND

1790: PARTNER.party_type = 'ORGANIZATION' AND
1791: HZR_PART_CONT.object_id = PARTNER.PARTY_ID AND
1792: HZR_PART_CONT.relationship_type = 'EMPLOYMENT' AND
1793: HZR_PART_CONT.subject_table_name = 'HZ_PARTIES' AND
1794: HZR_PART_CONT.object_table_name = 'HZ_PARTIES' AND
1795: HZR_PART_CONT.PARTY_ID = res.source_id and
1796: res.resource_id = pc_salesforce_id and
1797: HZR_PART_CONT.relationship_id = ORG_CONTACT.party_relationship_id AND
1798: hcp.owner_table_id(+) = HZR_PART_CONT.PARTY_ID AND

Line 1800: hcp.owner_table_name(+) = 'HZ_PARTIES' and

1796: res.resource_id = pc_salesforce_id and
1797: HZR_PART_CONT.relationship_id = ORG_CONTACT.party_relationship_id AND
1798: hcp.owner_table_id(+) = HZR_PART_CONT.PARTY_ID AND
1799: hcp.CONTACT_POINT_TYPE(+) = 'PHONE' AND
1800: hcp.owner_table_name(+) = 'HZ_PARTIES' and
1801: hcp.primary_flag(+) ='Y'
1802: ;
1803:
1804: cursor lc_get_nature_of_resource (pc_access_id number) is