DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on HR_PERSON_FLEX_LOGIC

Line 4477: = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

4473: WHERE nvl(business_group_id,0) = 0 -- added as part of bug 7613549
4474: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
4475: AND formula_name = 'HR_PA_MOVE'
4476: AND formula_type_id
4477: = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
4478:
4479: CURSOR c_leav_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4480: IS
4481: SELECT leaving_reason

Line 4524: l_term_type := HR_PERSON_FLEX_LOGIC.GetTermType(p_term_formula_id => l_formula_id

4520: OPEN c_leav_reas(p_person_id);
4521: FETCH c_leav_reas INTO l_leav_reas;
4522: IF c_leav_reas%FOUND THEN
4523: CLOSE c_leav_reas;
4524: l_term_type := HR_PERSON_FLEX_LOGIC.GetTermType(p_term_formula_id => l_formula_id
4525: ,p_leaving_reason => l_leav_reas
4526: ,p_session_date => sysdate);
4527: ELSE
4528: CLOSE c_leav_reas;

Line 4538: l_term_type := HR_PERSON_FLEX_LOGIC.GetTermType(p_term_formula_id => l_formula_id

4534: OPEN c_term_reas(p_person_id);
4535: FETCH c_term_reas INTO l_term_reas;
4536: IF c_term_reas%FOUND THEN
4537: CLOSE c_term_reas;
4538: l_term_type := HR_PERSON_FLEX_LOGIC.GetTermType(p_term_formula_id => l_formula_id
4539: ,p_leaving_reason => l_term_reas
4540: ,p_session_date => sysdate);
4541: ELSE
4542: CLOSE c_term_reas;