[Home] [Help]
838:
839: -- Get the party role code associated with the given contract.
840: CURSOR party_csr IS
841: SELECT party_id, party_role_code
842: FROM okc_rep_contract_parties
843: WHERE contract_id = p_contract_id;
844:
845: party_rec party_csr%ROWTYPE;
846:
860: 'Input parameter is: p_contract_id = ' || p_contract_id||
861: '.');
862: END IF;
863:
864: -- 1. Get party_role_code from okc_rep_contract_parties
865: -- for the given contract_id.
866: -- 2. For each record from step 1:
867: FOR party_rec IN party_csr
868: LOOP