APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on PER_PAY_PROPOSALS

Line 3428: from per_pay_proposals ppp

3424:
3425: --
3426: cursor c_pay_proposal (cv_pay_proposal_id number) is
3427: select ppp.object_version_number
3428: from per_pay_proposals ppp
3429: where ppp.pay_proposal_id = cv_pay_proposal_id;
3430: --
3431: cursor c_pen_sus is
3432: select pen.prtt_enrt_rslt_id,

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

5258: p_person_id => l_person_id,
5259: p_object_version_number => l_object_version_number,
5260: p_effective_date => l_prv_effective_date);
5261: --
5262: if l_ref_obj_pk_id is not null and l_ref_obj_table_name = 'PER_PAY_PROPOSALS'
5263: then
5264: --
5265: l_salary_proposal_ovn := null;
5266: open c_pay_proposal(l_ref_obj_pk_id);

Line 5272: -- Delete the per pay proposals.

5268: close c_pay_proposal;
5269: --
5270: if l_salary_proposal_ovn is not null then
5271: --
5272: -- Delete the per pay proposals.
5273: --
5274: hr_maintain_proposal_api.delete_salary_proposal(
5275: p_pay_proposal_id => l_ref_obj_pk_id
5276: ,p_business_group_id => p_business_group_id