APPS.PV_PARTNER_MIGRATIONS_PUB dependencies on PV_PARTNER_PROFILES

Line 77: PV_PARTNER_PROFILES,

73: CURSOR GET_PARTY_NAME(CV_PARTNER_ID INTEGER) IS
74: SELECT
75: PARTY_NAME, PARTY_ID
76: FROM
77: PV_PARTNER_PROFILES,
78: HZ_PARTIES
79: WHERE
80: HZ_PARTIES.PARTY_ID = PV_PARTNER_PROFILES.PARTNER_PARTY_ID AND
81: PV_PARTNER_PROFILES.PARTNER_ID = CV_PARTNER_ID;

Line 80: HZ_PARTIES.PARTY_ID = PV_PARTNER_PROFILES.PARTNER_PARTY_ID AND

76: FROM
77: PV_PARTNER_PROFILES,
78: HZ_PARTIES
79: WHERE
80: HZ_PARTIES.PARTY_ID = PV_PARTNER_PROFILES.PARTNER_PARTY_ID AND
81: PV_PARTNER_PROFILES.PARTNER_ID = CV_PARTNER_ID;
82:
83:
84: CURSOR GET_PARTNER_TYPE_DTLS(CV_PARTNER_ID INTEGER) is

Line 81: PV_PARTNER_PROFILES.PARTNER_ID = CV_PARTNER_ID;

77: PV_PARTNER_PROFILES,
78: HZ_PARTIES
79: WHERE
80: HZ_PARTIES.PARTY_ID = PV_PARTNER_PROFILES.PARTNER_PARTY_ID AND
81: PV_PARTNER_PROFILES.PARTNER_ID = CV_PARTNER_ID;
82:
83:
84: CURSOR GET_PARTNER_TYPE_DTLS(CV_PARTNER_ID INTEGER) is
85: select ATTR_VALUE from pv_enty_attr_values tabl where entity_id = CV_PARTNER_ID and ATTRIBUTE_id= 3

Line 277: (select count(status) from pv_partner_profiles where status = 'A') Active,

273:
274: -- Cursor to get the count for all 'Active' and 'Inactive' Partners.
275: CURSOR Get_Partner_Status_Count is
276: SELECT
277: (select count(status) from pv_partner_profiles where status = 'A') Active,
278: (select count(status) from pv_partner_profiles where status = 'I') Inactive
279:
280: FROM DUAL;
281:

Line 278: (select count(status) from pv_partner_profiles where status = 'I') Inactive

274: -- Cursor to get the count for all 'Active' and 'Inactive' Partners.
275: CURSOR Get_Partner_Status_Count is
276: SELECT
277: (select count(status) from pv_partner_profiles where status = 'A') Active,
278: (select count(status) from pv_partner_profiles where status = 'I') Inactive
279:
280: FROM DUAL;
281:
282: -- Cursor to get all partners with VAD partner types.

Line 334: pv_partner_profiles profiles

330: AND attr_value_extn is not null
331: )
332: )
333: partners,
334: pv_partner_profiles profiles
335: WHERE partners.entity_id = profiles.partner_id
336: AND profiles.status in ('A', 'I');
337:
338: -- Cursor to get all partners with other partner types.

Line 395: pv_partner_profiles ppp

391: group by entity_id
392: ) sorted,
393: pv_enty_attr_values details,
394: fnd_lookup_values match,
395: pv_partner_profiles ppp
396: where
397: details.attr_value = lookup_code and
398: match.lookup_type = 'PV_PARTNER_TYPE_RANKING' and
399: match.language = userenv('LANG') and

Line 414: pv_partner_profiles profiles

410: attr_value,
411: entity_id
412: FROM
413: pv_enty_attr_values partners,
414: pv_partner_profiles profiles
415: WHERE
416: partners.attribute_id = 3
417: AND partners.latest_flag = 'Y'
418: AND partners.attr_value = 'VAD'

Line 438: pv_partner_profiles ppp

434: attr_value,
435: entity_id
436: FROM pv_enty_attr_values attr,
437: fnd_lookup_values lkp,
438: pv_partner_profiles ppp
439: WHERE
440: attribute_id = 3
441: AND latest_flag = 'Y'
442: AND entity_id not in (