APPS.PV_CONTEXT_VALUES dependencies on PV_PARTNER_PROFILES

Line 665: FROM pv_partner_profiles

661: -- in the refresh.
662: -- -----------------------------------------------------------------------------
663: OPEN lc_get_partners FOR
664: SELECT partner_id
665: FROM pv_partner_profiles
666: WHERE status = 'A' AND
667: --sales_partner_flag = 'Y'
668: partner_resource_id IS NOT NULL;
669: END IF;

Line 1023: FROM pv_partner_profiles pvpp

1019: -- Set partner SQL
1020: -- ---------------------------------------------------------
1021: l_partner_sql :=
1022: 'SELECT partner_id
1023: FROM pv_partner_profiles pvpp
1024: WHERE pvpp.status = ''A'' AND
1025: partner_resource_id IS NOT NULL AND
1026: creation_date >= :last_incr_refresh ';
1027:

Line 1062: pv_partner_profiles b,

1058: Debug('----------' || ' ' || '-------------------------------');
1059:
1060: For x IN (SELECT a.partner_id, c.party_name
1061: FROM pv_partner_id_session a,
1062: pv_partner_profiles b,
1063: hz_parties c
1064: WHERE a.partner_id = b.partner_id AND
1065: b.partner_party_id = c.party_id)
1066: LOOP

Line 1697: pv_partner_profiles PV

1693: a.attr_value attr_text,
1694: pv_check_match_pub.Currency_Conversion(
1695: a.attr_value, g_common_currency) attr_value
1696: FROM pv_enty_attr_values a,
1697: pv_partner_profiles PV
1698: WHERE a.entity = 'PARTNER' AND
1699: a.latest_flag = 'Y' AND
1700: a.entity_id = PV.partner_id AND
1701: PV.partner_resource_id IS NOT NULL AND

Line 1893: pv_partner_profiles PV

1889: 1.0
1890: FROM (
1891: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
1892: FROM pv_enty_attr_values a,
1893: pv_partner_profiles PV
1894: WHERE a.entity = 'PARTNER' AND
1895: a.latest_flag = 'Y' AND
1896: a.attr_value IS NOT NULL AND
1897: a.entity_id = PV.partner_id AND

Line 2012: pv_partner_profiles PV

2008: 1.0
2009: FROM (
2010: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
2011: FROM pv_enty_attr_values a,
2012: pv_partner_profiles PV
2013: WHERE a.entity = 'PARTNER' AND
2014: a.latest_flag = 'Y' AND
2015: a.attr_value IS NOT NULL AND
2016: DECODE(a.attribute_id, 3, attr_value_extn, 'Y') = 'Y' AND