DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on OKC_REP_CONTRACT_PARTIES

Line 848: FROM okc_rep_contract_parties

844:
845: -- Get the party role code associated with the given contract.
846: CURSOR party_csr IS
847: SELECT party_id, party_role_code
848: FROM okc_rep_contract_parties
849: WHERE contract_id = p_contract_id;
850:
851: party_rec party_csr%ROWTYPE;
852:

Line 870: -- 1. Get party_role_code from okc_rep_contract_parties

866: 'Input parameter is: p_contract_id = ' || p_contract_id||
867: '.');
868: END IF;
869:
870: -- 1. Get party_role_code from okc_rep_contract_parties
871: -- for the given contract_id.
872: -- 2. For each record from step 1:
873: FOR party_rec IN party_csr
874: LOOP