[Home] [Help]
505: cursor l_valid_partner_id(cv_partner_id IN NUMBER, cv_party_id IN Number) is
506: select
507: 'Y'
508: from
509: pv_partner_profiles
510: where
511: partner_id = cv_partner_id and
512: partner_party_id = cv_party_id;
513: -- and status = 'A';
518: 'Y',
519: hz_parties.party_id
520:
521: from
522: pv_partner_profiles,
523: hz_parties
524:
525: where
526: partner_id = cv_partner_id and
523: hz_parties
524:
525: where
526: partner_id = cv_partner_id and
527: -- pv_partner_profiles.status = 'A' and
528: party_id = partner_party_id and
529: hz_parties.status = 'A' and
530: hz_parties.party_type = 'ORGANIZATION';
531:
709: CURSOR l_get_partner_id(cv_party_id IN NUMBER) IS
710: SELECT
711: partner_id
712: FROM
713: pv_partner_profiles
714:
715: WHERE
716: partner_party_id = cv_party_id;
717: -- and status = 'A';
1237: ,max_users
1238: ,partner_party_id
1239: ,status
1240:
1241: FROM PV_PARTNER_PROFILES
1242: WHERE partner_profile_id = p_prtnr_prfls_rec.partner_profile_id;
1243:
1244: l_prtnr_prfls_rec PVX_PRTNR_PRFLS_PVT.prtnr_prfls_rec_type;
1245:
1449: CURSOR l_get_partner_level(cv_partner_id IN number) is
1450: select
1451: attr_code
1452: from
1453: pv_partner_profiles val,
1454: pv_attribute_codes_b cod
1455: where
1456: cod.attr_code_id = val.partner_level and
1457: val.partner_id = cv_partner_id;
1468: CURSOR l_get_partner_profile_id(cv_partner_id IN varchar2) IS
1469: select
1470: partner_profile_id
1471: from
1472: pv_partner_profiles
1473: where
1474: partner_id = cv_partner_id;
1475:
1476: CURSOR l_get_partner_type(cv_partner_id IN NUMBER) IS
1779: SELECT
1780: partner_id
1781:
1782: FROM
1783: pv_partner_profiles
1784:
1785: WHERE
1786: partner_party_id = cv_party_id;
1787: -- and status = 'A';