APPS.PV_ASSIGNMENT_PVT dependencies on HZ_RELATIONSHIPS

Line 724: from hz_relationships EMP_TO_ORG,

720: */
721:
722: CURSOR lc_get_vad_assign (pc_lead_assignment_id number) IS
723: select pv_assign.lead_assignment_id
724: from hz_relationships EMP_TO_ORG,
725: hz_relationships ORG_TO_VEND,
726: hz_organization_profiles HZOP,
727: pv_lead_assignments PV_ASSIGN,
728: pv_lead_workflows PV_LEAD_WF,

Line 725: hz_relationships ORG_TO_VEND,

721:
722: CURSOR lc_get_vad_assign (pc_lead_assignment_id number) IS
723: select pv_assign.lead_assignment_id
724: from hz_relationships EMP_TO_ORG,
725: hz_relationships ORG_TO_VEND,
726: hz_organization_profiles HZOP,
727: pv_lead_assignments PV_ASSIGN,
728: pv_lead_workflows PV_LEAD_WF,
729: jtf_rs_resource_extns LEAD_SOURCE,

Line 1244: hz_relationships b,

1240: d.lead_id, 'PARTY', c.resource_id
1241: from
1242: pv_lead_assignments la,
1243: pv_partner_profiles pvpp,
1244: hz_relationships b,
1245: jtf_rs_resource_extns c,
1246: as_accesses_all d
1247: where
1248: la.wf_item_type = pc_itemtype and

Line 1321: hz_relationships b,

1317: d.lead_id, 'PARTY', c.resource_id
1318: FROM
1319: pv_lead_assignments la,
1320: pv_partner_profiles pvpp,
1321: hz_relationships b,
1322: jtf_rs_resource_extns c,
1323: as_accesses_all d
1324: WHERE
1325: la.wf_item_type = pc_itemtype

Line 1718: 'hz_parties partner, hz_relationships hzrl, hz_organization_profiles hzop '||

1714: elsif p_timeoutType = pv_assignment_pub.g_offered_timeout then
1715:
1716: l_query := l_query || ' ( select hzl.country from '||
1717: 'hz_locations hzl, hz_party_sites hzps, pv_lead_assignments lead, '||
1718: 'hz_parties partner, hz_relationships hzrl, hz_organization_profiles hzop '||
1719: 'where hzl.location_id = hzps.location_id '||
1720: 'and hzps.party_id = partner.party_id '||
1721: 'and hzrl.party_id = lead.partner_id '||
1722: 'and hzrl.subject_id = partner.party_id '||

Line 2098: from hz_relationships pr,

2094: l_resource_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
2095:
2096: cursor lc_get_pt_org_name (pc_partner_id number) is
2097: select pt.party_name
2098: from hz_relationships pr,
2099: hz_organization_profiles op,
2100: hz_parties pt
2101: where pr.party_id = pc_partner_id
2102: and pr.subject_table_name = 'HZ_PARTIES'

Line 3528: from hz_relationships pr,

3524: order by 5,4;
3525:
3526: cursor lc_get_pt_org_name (pc_partner_id number) is
3527: select pt.party_name
3528: from hz_relationships pr,
3529: hz_organization_profiles op,
3530: hz_parties pt
3531: where pr.party_id = pc_partner_id
3532: and pr.subject_table_name = 'HZ_PARTIES'