APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_PAY_PROPOSALS

Line 1722: from per_pay_proposals

1718: --
1719: -- Bug 4644830 Start
1720: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1721: select pay_proposal_id,object_version_number,proposed_salary_n, change_date, proposal_reason -- Added For Bug 5987409 --
1722: from per_pay_proposals
1723: where assignment_id=ass_id
1724: and approved = 'N'
1725: order by change_date desc;
1726: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

Line 1726: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

1722: from per_pay_proposals
1723: where assignment_id=ass_id
1724: and approved = 'N'
1725: order by change_date desc;
1726: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1727: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1728: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1729: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1730: l_inv_next_sal_date_warning boolean := false;

Line 1727: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;

1723: where assignment_id=ass_id
1724: and approved = 'N'
1725: order by change_date desc;
1726: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1727: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1728: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1729: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1730: l_inv_next_sal_date_warning boolean := false;
1731: l_proposed_salary_warning boolean := false;

Line 1728: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

1724: and approved = 'N'
1725: order by change_date desc;
1726: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1727: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1728: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1729: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1730: l_inv_next_sal_date_warning boolean := false;
1731: l_proposed_salary_warning boolean := false;
1732: l_approved_warning boolean := false;

Line 1729: l_dummy_change_date per_pay_proposals.change_date%TYPE;

1725: order by change_date desc;
1726: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1727: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1728: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1729: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1730: l_inv_next_sal_date_warning boolean := false;
1731: l_proposed_salary_warning boolean := false;
1732: l_approved_warning boolean := false;
1733: l_payroll_warning boolean := false;

Line 1734: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --

1730: l_inv_next_sal_date_warning boolean := false;
1731: l_proposed_salary_warning boolean := false;
1732: l_approved_warning boolean := false;
1733: l_payroll_warning boolean := false;
1734: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --
1735: -- Bug 4644830 End
1736: --
1737: -- start of bug 4641965
1738: l_pspl_asg_id per_all_assignments_f.assignment_id%type;

Line 1741: from per_pay_proposals

1737: -- start of bug 4641965
1738: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
1739: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1740: select pay_proposal_id,object_version_number
1741: from per_pay_proposals
1742: where assignment_id=ass_id
1743: and APPROVED='N';
1744: -- end 4641965
1745:

Line 1756: from per_pay_proposals

1752: l_bg_id number;
1753:
1754: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1755: select pay_proposal_id
1756: from per_pay_proposals
1757: where assignment_id=ass_id
1758: and APPROVED='Y';
1759:
1760: --Bug 4959033 ends here