DBA Data[Home] [Help]

APPS.HREMPTER dependencies on PER_PAY_PROPOSALS

Line 1086: from per_pay_proposals ppp

1082: ,p_term_date date
1083: ,p_term_rule varchar2) is
1084: select ppp.pay_proposal_id
1085: , ppp.multiple_components
1086: from per_pay_proposals ppp
1087: , per_all_assignments_f asg
1088: , per_pay_bases ppb
1089: , pay_element_types_f pet
1090: , pay_input_values_f piv

Line 1784: --delete from per_pay_proposals pp

1780: hr_utility.set_location(l_proc,90);
1781: --
1782: -- VT #375157 06/28/96
1783: -- Remove any pay proposals for which there are no element entries.
1784: --delete from per_pay_proposals pp
1785: --where pp.assignment_id = p_assignment_id
1786: -- and not exists
1787: -- (select null
1788: -- from pay_element_entries_f ee

Line 1806: DELETE FROM per_pay_proposals

1802: DELETE FROM per_pay_proposal_components
1803: WHERE pay_proposal_id=pay_rec.pay_proposal_id;
1804: end if;
1805: --
1806: DELETE FROM per_pay_proposals
1807: WHERE pay_proposal_id=pay_rec.pay_proposal_id;
1808: --
1809: hr_utility.set_location(l_proc,120);
1810: --