APPS.PER_PL_TERMINATION dependencies on PER_PERIODS_OF_SERVICE

Line 4: PROCEDURE REVERSE(p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE

1: PACKAGE BODY PER_PL_TERMINATION as
2: /* $Header: peplterp.pkb 120.0 2006/03/01 22:41:38 mseshadr noship $ */
3:
4: PROCEDURE REVERSE(p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE
5: ,p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE
6: ,p_leaving_reason per_periods_of_service.leaving_reason%TYPE) is
7:
8: cursor csr_normal_assignments is

Line 5: ,p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE

1: PACKAGE BODY PER_PL_TERMINATION as
2: /* $Header: peplterp.pkb 120.0 2006/03/01 22:41:38 mseshadr noship $ */
3:
4: PROCEDURE REVERSE(p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE
5: ,p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE
6: ,p_leaving_reason per_periods_of_service.leaving_reason%TYPE) is
7:
8: cursor csr_normal_assignments is
9: select distinct(paaf.assignment_id)

Line 6: ,p_leaving_reason per_periods_of_service.leaving_reason%TYPE) is

2: /* $Header: peplterp.pkb 120.0 2006/03/01 22:41:38 mseshadr noship $ */
3:
4: PROCEDURE REVERSE(p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE
5: ,p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE
6: ,p_leaving_reason per_periods_of_service.leaving_reason%TYPE) is
7:
8: cursor csr_normal_assignments is
9: select distinct(paaf.assignment_id)
10: from per_all_assignments_f paaf

Line 135: PROCEDURE ACTUAL_TERMINATION_EMP(p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE

131: hr_utility.set_location('Leaving: '||l_proc,30);
132: end if;
133:
134: End REVERSE;
135: PROCEDURE ACTUAL_TERMINATION_EMP(p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE
136: ,p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE
137: ,p_business_group_id NUMBER) is
138: -------------------------------------------------------------------------+
139: -- -+

Line 136: ,p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE

132: end if;
133:
134: End REVERSE;
135: PROCEDURE ACTUAL_TERMINATION_EMP(p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE
136: ,p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE
137: ,p_business_group_id NUMBER) is
138: -------------------------------------------------------------------------+
139: -- -+
140: -- Name : ACTUAL_TERMINATION_EMP -+