11: procedure initiate(p_period_of_service_id number) is
12: --
13: cursor c_get_pds is
14: select person_id
15: from per_periods_of_service
16: where period_of_service_id = p_period_of_service_id;
17: --
18: l_proc varchar2(72) := g_package || '.intiate';
19: begin
463: l_leaving_reason varchar2(30);
464: --
465: cursor c_get_pds is
466: select leaving_reason
467: from per_periods_of_service
468: where period_of_service_id = p_period_of_service_id;
469: --
470: begin
471:
805: ,effective_end_date
806: from per_contracts_f c
807: where person_id =
808: (select person_id
809: from per_periods_of_service
810: where period_of_service_id = p_period_of_service_id)
811: and p_actual_termination_date = effective_end_date;
812: --
813: cursor c_get_ctr2 (p_contract_id number