542: );
543:
544:
545: --Cursor to fetch person no based on person id
546: CURSOR c_person_no (c_person_id hz_parties.party_id%TYPE)
547: IS
548: SELECT party_number
549: FROM hz_parties
550: WHERE party_id = c_person_id;
545: --Cursor to fetch person no based on person id
546: CURSOR c_person_no (c_person_id hz_parties.party_id%TYPE)
547: IS
548: SELECT party_number
549: FROM hz_parties
550: WHERE party_id = c_person_id;
551:
552: l_person_no c_person_no%ROWTYPE;
553: