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 1001: FROM pv_partner_profiles pvpp

997: -- Set partner SQL
998: -- ---------------------------------------------------------
999: l_partner_sql :=
1000: 'SELECT partner_id
1001: FROM pv_partner_profiles pvpp
1002: WHERE pvpp.status = ''A'' AND
1003: partner_resource_id IS NOT NULL AND
1004: creation_date >= :last_incr_refresh ';
1005:

Line 1040: pv_partner_profiles b,

1036: Debug('----------' || ' ' || '-------------------------------');
1037:
1038: For x IN (SELECT a.partner_id, c.party_name
1039: FROM pv_partner_id_session a,
1040: pv_partner_profiles b,
1041: hz_parties c
1042: WHERE a.partner_id = b.partner_id AND
1043: b.partner_party_id = c.party_id)
1044: LOOP

Line 1675: pv_partner_profiles PV

1671: a.attr_value attr_text,
1672: pv_check_match_pub.Currency_Conversion(
1673: a.attr_value, g_common_currency) attr_value
1674: FROM pv_enty_attr_values a,
1675: pv_partner_profiles PV
1676: WHERE a.entity = 'PARTNER' AND
1677: a.latest_flag = 'Y' AND
1678: a.entity_id = PV.partner_id AND
1679: PV.partner_resource_id IS NOT NULL AND

Line 1871: pv_partner_profiles PV

1867: 1.0
1868: FROM (
1869: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
1870: FROM pv_enty_attr_values a,
1871: pv_partner_profiles PV
1872: WHERE a.entity = 'PARTNER' AND
1873: a.latest_flag = 'Y' AND
1874: a.attr_value IS NOT NULL AND
1875: a.entity_id = PV.partner_id AND

Line 1990: pv_partner_profiles PV

1986: 1.0
1987: FROM (
1988: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
1989: FROM pv_enty_attr_values a,
1990: pv_partner_profiles PV
1991: WHERE a.entity = 'PARTNER' AND
1992: a.latest_flag = 'Y' AND
1993: a.attr_value IS NOT NULL AND
1994: DECODE(a.attribute_id, 3, attr_value_extn, 'Y') = 'Y' AND