Salary Basis is required for employee before running the payroll,once the payroll basis is assigned to an employee the data will be stored in the table per_pay_proposals.
The link between per_pay_proposals and per_all_assignments_f is based on the assignment_id.
Below is the API(with sample parameters) for updating or creating the salary basis for an employee.
hr_maintain_proposal_api.insert_salary_proposal (
p_pay_proposal_id => l_proposal_id,
p_assignment_id => i.assignment_id,
p_business_group_id => i.business_group_id,
p_object_version_number => l_object_version_number,
p_multiple_components => 'N',
p_change_date => to_date('01-JAN-2013','DD/MM/YYYY'),--l_effective_date , --to_date('01-JAN-2013','DD/MM/YYYY'), --
p_proposal_reason => i.reason,
p_proposed_salary_n => i.salary,
p_approved => i.approved,
p_element_entry_id => l_element_entry_id,
p_validate => l_validate,
p_inv_next_sal_date_warning => l_inv_next_sal_date_warning,
p_proposed_salary_warning => l_proposed_salary_warning,
p_approved_warning => l_approved_warning,
p_payroll_warning => l_payroll_warning);
The link between per_pay_proposals and per_all_assignments_f is based on the assignment_id.
Below is the API(with sample parameters) for updating or creating the salary basis for an employee.
hr_maintain_proposal_api.insert_salary_proposal (
p_pay_proposal_id => l_proposal_id,
p_assignment_id => i.assignment_id,
p_business_group_id => i.business_group_id,
p_object_version_number => l_object_version_number,
p_multiple_components => 'N',
p_change_date => to_date('01-JAN-2013','DD/MM/YYYY'),--l_effective_date , --to_date('01-JAN-2013','DD/MM/YYYY'), --
p_proposal_reason => i.reason,
p_proposed_salary_n => i.salary,
p_approved => i.approved,
p_element_entry_id => l_element_entry_id,
p_validate => l_validate,
p_inv_next_sal_date_warning => l_inv_next_sal_date_warning,
p_proposed_salary_warning => l_proposed_salary_warning,
p_approved_warning => l_approved_warning,
p_payroll_warning => l_payroll_warning);
No comments:
Post a Comment