APPS.HRENTMNT dependencies on PER_PAY_PROPOSALS

Line 580: from per_pay_proposals pp

576: --
577: -- bug 9648525 remove proposal components as well as proposal
578: delete from per_pay_proposal_components ppc
579: where ppc.pay_proposal_id in ( select pp.pay_proposal_id
580: from per_pay_proposals pp
581: where pp.assignment_id = p_assignment_id
582: and pp.pay_proposal_id = p_pay_proposal_id
583: and not exists
584: (select null

Line 590: delete from per_pay_proposals pp

586: where ee.assignment_id = pp.assignment_id
587: and ee.creator_type = 'SP'
588: and ee.creator_id = pp.pay_proposal_id));
589: --
590: delete from per_pay_proposals pp
591: where pp.assignment_id = p_assignment_id
592: and pp.pay_proposal_id = p_pay_proposal_id
593: and not exists
594: (select null

Line 2692: PER_PAY_PROPOSALS pp

2688: NOT EXISTS
2689: (SELECT pb.pay_basis_id
2690: FROM PER_PAY_BASES pb,
2691: PAY_INPUT_VALUES_F iv,
2692: PER_PAY_PROPOSALS pp
2693: WHERE iv.element_type_id = el.element_type_id
2694: and iv.effective_start_date <= asg.effective_end_date /*Bug 7662923 */
2695: and iv.effective_end_date >= asg.effective_start_date
2696: and pb.input_value_id = iv.input_value_id

Line 3190: UPDATE PER_PAY_PROPOSALS pp

3186: if g_debug then
3187: hr_utility.trace ('***** maintain end date of PP >' ||
3188: (p_validation_end_date + 1) || '<');
3189: end if;
3190: UPDATE PER_PAY_PROPOSALS pp
3191: SET pp.change_date = p_validation_end_date + 1
3192: WHERE pp.assignment_id = p_assignment_id
3193: and pp.pay_proposal_id = p_ee_creator_id
3194: ;