279: l_person_id number;
280: --
281: cursor csr_in_per_contracts is
282: select pc.effective_start_date, pc.business_group_id, pc.person_id
283: from per_contracts_f pc
284: where pc.contract_id = p_contract_id
285: and pc.effective_start_date =
286: (select min(pc1.effective_start_date)
287: from per_contracts_f pc1
283: from per_contracts_f pc
284: where pc.contract_id = p_contract_id
285: and pc.effective_start_date =
286: (select min(pc1.effective_start_date)
287: from per_contracts_f pc1
288: where pc1.contract_id = p_contract_id
289: and pc1.contract_id = pc.contract_id);
290: --
291: begin