APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on PER_PAY_PROPOSALS

Line 3904: from per_pay_proposals ppp

3900:
3901: --
3902: cursor c_pay_proposal (cv_pay_proposal_id number) is
3903: select ppp.object_version_number
3904: from per_pay_proposals ppp
3905: where ppp.pay_proposal_id = cv_pay_proposal_id;
3906: --
3907: cursor c_pen_sus is
3908: select pen.prtt_enrt_rslt_id,

Line 5744: if l_ref_obj_pk_id is not null and l_ref_obj_table_name = 'PER_PAY_PROPOSALS'

5740: p_person_id => l_person_id,
5741: p_object_version_number => l_object_version_number,
5742: p_effective_date => l_prv_effective_date);
5743: --
5744: if l_ref_obj_pk_id is not null and l_ref_obj_table_name = 'PER_PAY_PROPOSALS'
5745: then
5746: --
5747: l_salary_proposal_ovn := null;
5748: open c_pay_proposal(l_ref_obj_pk_id);

Line 5754: -- Delete the per pay proposals.

5750: close c_pay_proposal;
5751: --
5752: if l_salary_proposal_ovn is not null then
5753: --
5754: -- Delete the per pay proposals.
5755: --
5756: hr_maintain_proposal_api.delete_salary_proposal(
5757: p_pay_proposal_id => l_ref_obj_pk_id
5758: ,p_business_group_id => p_business_group_id