APPS.HRENTMNT dependencies on PER_PAY_PROPOSALS

Line 750: delete from per_pay_proposals pp

746: begin
747: --
748: -- Remove the pay proposal if there are no element entries for it.
749: --
750: delete from per_pay_proposals pp
751: where pp.assignment_id = p_assignment_id
752: and pp.pay_proposal_id = p_pay_proposal_id
753: and not exists
754: (select null

Line 2361: PER_PAY_PROPOSALS pp

2357: NOT EXISTS
2358: (SELECT pb.pay_basis_id
2359: FROM PER_PAY_BASES pb,
2360: PAY_INPUT_VALUES_F iv,
2361: PER_PAY_PROPOSALS pp
2362: WHERE iv.element_type_id = el.element_type_id
2363: and iv.effective_start_date <= asg.effective_start_date
2364: and iv.effective_end_date >= asg.effective_start_date
2365: and pb.input_value_id = iv.input_value_id

Line 2788: UPDATE PER_PAY_PROPOSALS pp

2784: if g_debug then
2785: hr_utility.trace ('***** maintain end date of PP >' ||
2786: (p_validation_end_date + 1) || '<');
2787: end if;
2788: UPDATE PER_PAY_PROPOSALS pp
2789: SET pp.change_date = p_validation_end_date + 1
2790: WHERE pp.assignment_id = p_assignment_id
2791: and pp.pay_proposal_id = p_ee_creator_id
2792: ;