APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on PER_PAY_PROPOSALS

Line 6: procedure delete_per_pay_proposals(p_period_of_service_id number

2: /* $Header: pepds01t.pkb 120.1 2005/11/03 06:25:01 bshukla noship $ */
3: ----------------------------------------------------------------------------
4:
5: ----------------------------------------------------------------------------
6: procedure delete_per_pay_proposals(p_period_of_service_id number
7: ,p_actual_termination_date date) is
8: --
9: cursor ass1 is select pa.assignment_id
10: from per_assignments pa

Line 16: from per_pay_proposals pp

12: --
13: -- VT #464380 05/14/97
14: cursor ppr1 (p_assignment_id_in number) is
15: select pp.pay_proposal_id
16: from per_pay_proposals pp
17: where pp.assignment_id = p_assignment_id_in
18: and pp.change_date > p_actual_termination_date;
19: --
20: p_pay_proposal_id number;

Line 40: delete from per_pay_proposals

36: fetch ppr1 into p_pay_proposal_id;
37: end loop;
38: close ppr1;
39: --
40: delete from per_pay_proposals
41: where assignment_id = p_assignment_id
42: and change_date > p_actual_termination_date;
43: --
44: fetch ass1 into p_assignment_id;

Line 47: end delete_per_pay_proposals;

43: --
44: fetch ass1 into p_assignment_id;
45: end loop;
46: close ass1;
47: end delete_per_pay_proposals;
48: ----------------------------------------------------------------------------
49: procedure get_years_months(p_session_date IN DATE,
50: p_period_of_service_id IN NUMBER,
51: p_business_group_id IN NUMBER,

Line 1268: per_periods_of_service_pkg.delete_per_pay_proposals(

1264: /* This delete is now doen in hrempter.terminate_employee so that the
1265: deletion of pay proposals can be kept in step with the deletion
1266: of elements.
1267:
1268: per_periods_of_service_pkg.delete_per_pay_proposals(
1269: p_period_of_service_id => p_period_of_service_id
1270: ,p_actual_termination_date => p_actual_termination_date);
1271: */
1272: hrempter.terminate_employee('POST_UPDATE'