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.2 2011/09/16 10:04:54 srannama ship $ */
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 1269: per_periods_of_service_pkg.delete_per_pay_proposals(

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