APPS.PV_ASSIGNMENT_PVT dependencies on HZ_ORGANIZATION_PROFILES

Line 726: hz_organization_profiles HZOP,

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,
730: pv_enty_attr_values PEAV

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 2099: hz_organization_profiles op,

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'
2103: and pr.object_table_name = 'HZ_PARTIES'

Line 3529: hz_organization_profiles op,

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'
3533: and pr.object_table_name = 'HZ_PARTIES'