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;
82:
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