DBA Data[Home] [Help]

APPS.GHR_CORR_CANC_SF52 dependencies on PER_PAY_PROPOSALS

Line 4631: from per_pay_proposals ppp

4627: Cursor Cur_proposal_exists (p_assignment_id IN NUMBER,
4628: p_eff_date IN DATE) is
4629: Select ppp.pay_proposal_id proposal_id
4630: ,ppp.object_version_number ovn
4631: from per_pay_proposals ppp
4632: where ppp.assignment_id = p_assignment_id
4633: and change_date <= p_eff_date;
4634:
4635: l_pay_proposal_id NUMBER;

Line 4730: per_pay_proposals_populate.GET_ELEMENT_ID(

4726: p_validate => FALSE ,
4727: p_salary_warning => l_sal_warn
4728: ); */
4729:
4730: per_pay_proposals_populate.GET_ELEMENT_ID(
4731: p_assignment_id => p_assignment_id,
4732: p_business_group_id => l_business_group_id,
4733: p_change_date => p_date_effective -1,
4734: p_payroll_value => l_payroll_value,