APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PER_PAY_PROPOSALS

Line 18: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

14: -- bug 5032032
15: PROCEDURE update_salary_proposal(p_assignment_id number
16: , p_effective_date date) IS
17:
18: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
19: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
20: l_change_date per_pay_proposals.change_date%TYPE;
21: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
22: l_approved_flag varchar2(1) := 'Y';

Line 19: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;

15: PROCEDURE update_salary_proposal(p_assignment_id number
16: , p_effective_date date) IS
17:
18: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
19: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
20: l_change_date per_pay_proposals.change_date%TYPE;
21: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
22: l_approved_flag varchar2(1) := 'Y';
23: l_inv_next_sal_date_warning boolean;

Line 20: l_change_date per_pay_proposals.change_date%TYPE;

16: , p_effective_date date) IS
17:
18: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
19: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
20: l_change_date per_pay_proposals.change_date%TYPE;
21: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
22: l_approved_flag varchar2(1) := 'Y';
23: l_inv_next_sal_date_warning boolean;
24: l_proposed_salary_warning boolean;

Line 21: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;

17:
18: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
19: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
20: l_change_date per_pay_proposals.change_date%TYPE;
21: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
22: l_approved_flag varchar2(1) := 'Y';
23: l_inv_next_sal_date_warning boolean;
24: l_proposed_salary_warning boolean;
25: l_approved_warning boolean;

Line 31: from per_pay_proposals

27:
28: cursor csr_payproposal is
29: select pay_proposal_id, object_version_number, change_date
30: ,PROPOSED_SALARY_N
31: from per_pay_proposals
32: where assignment_id = p_assignment_id
33: order by change_date DESC;
34: BEGIN
35: open csr_payproposal;