eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HREMPTER dependencies on PER_PAY_PROPOSALS

Line 1104: from per_pay_proposals ppp

1100: ,p_term_date date
1101: ,p_term_rule varchar2) is
1102: select ppp.pay_proposal_id
1103: , ppp.multiple_components
1104: from per_pay_proposals ppp
1105: , per_all_assignments_f asg
1106: , per_pay_bases ppb
1107: , pay_element_types_f pet
1108: , pay_input_values_f piv

Line 1802: --delete from per_pay_proposals pp

1798: hr_utility.set_location(l_proc,90);
1799: --
1800: -- VT #375157 06/28/96
1801: -- Remove any pay proposals for which there are no element entries.
1802: --delete from per_pay_proposals pp
1803: --where pp.assignment_id = p_assignment_id
1804: -- and not exists
1805: -- (select null
1806: -- from pay_element_entries_f ee

Line 1824: DELETE FROM per_pay_proposals

1820: DELETE FROM per_pay_proposal_components
1821: WHERE pay_proposal_id=pay_rec.pay_proposal_id;
1822: end if;
1823: --
1824: DELETE FROM per_pay_proposals
1825: WHERE pay_proposal_id=pay_rec.pay_proposal_id;
1826: --
1827: hr_utility.set_location(l_proc,120);
1828: --