APPS.HR_CHANGE_START_DATE_API dependencies on PER_PAY_PROPOSALS

Line 1681: from per_pay_proposals

1677: ,p_type VARCHAR2) is
1678: cursor get_pay_proposal
1679: is
1680: select pay_proposal_id
1681: from per_pay_proposals
1682: where change_date = p_old_start_date
1683: and exists (select 1
1684: from per_assignments_f
1685: where person_id = p_person_id

Line 1686: and per_pay_proposals.assignment_id = per_assignments_f.assignment_id

1682: where change_date = p_old_start_date
1683: and exists (select 1
1684: from per_assignments_f
1685: where person_id = p_person_id
1686: and per_pay_proposals.assignment_id = per_assignments_f.assignment_id
1687: -- and primary_flag = 'Y'
1688: and effective_start_date = p_new_start_date
1689: and assignment_type = p_type);
1690: --

Line 1694: from per_pay_proposals

1690: --
1691: cursor prv_pay_proposals
1692: is
1693: select count(*)
1694: from per_pay_proposals
1695: where change_date <= p_new_start_date
1696: and assignment_id =
1697: (select assignment_id
1698: from per_assignments_f

Line 1708: from per_pay_proposals

1704: -- start changes for bug 8267359
1705: cursor get_updtd_proposal_rows
1706: is
1707: select pay_proposal_id
1708: from per_pay_proposals
1709: where Last_change_date = p_old_start_date
1710: and exists (select 1
1711: from per_assignments_f
1712: where person_id = p_person_id

Line 1713: and per_pay_proposals.assignment_id = per_assignments_f.assignment_id

1709: where Last_change_date = p_old_start_date
1710: and exists (select 1
1711: from per_assignments_f
1712: where person_id = p_person_id
1713: and per_pay_proposals.assignment_id = per_assignments_f.assignment_id
1714: and effective_start_date = p_new_start_date
1715: and assignment_type = p_type);
1716: -- end changes for bug 8267359
1717:

Line 1758: update per_pay_proposals

1754: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1755: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1756: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1757: --
1758: update per_pay_proposals
1759: set change_date = p_new_start_date
1760: where change_date = p_old_start_date
1761: and pay_proposal_id = l_pay_proposal_id;
1762: /* and assignment_id =

Line 1796: update per_pay_proposals

1792:
1793: BEGIN
1794: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,60);
1795: --
1796: update per_pay_proposals
1797: set last_change_date = p_new_start_date
1798: where last_change_date = p_old_start_date
1799: and pay_proposal_id = l_pay_proposal_id;
1800: