DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on HR_PERSON_FLEX_LOGIC

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

4809: WHERE nvl(business_group_id,0) = 0 -- added as part of bug 7613549
4810: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
4811: AND formula_name = 'HR_PA_MOVE'
4812: AND formula_type_id
4813: = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
4814:
4815: CURSOR c_leav_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4816: IS
4817: SELECT leaving_reason

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

4877: OPEN c_leav_reas(p_person_id);
4878: FETCH c_leav_reas INTO l_leav_reas;
4879: IF c_leav_reas%FOUND THEN
4880: CLOSE c_leav_reas;
4881: l_term_type := HR_PERSON_FLEX_LOGIC.GetTermType(p_term_formula_id => l_formula_id
4882: ,p_leaving_reason => l_leav_reas
4883: ,p_session_date => sysdate);
4884: ELSE
4885: CLOSE c_leav_reas;

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

4891: OPEN c_term_reas(p_person_id);
4892: FETCH c_term_reas INTO l_term_reas;
4893: IF c_term_reas%FOUND THEN
4894: CLOSE c_term_reas;
4895: l_term_type := HR_PERSON_FLEX_LOGIC.GetTermType(p_term_formula_id => l_formula_id
4896: ,p_leaving_reason => l_term_reas
4897: ,p_session_date => sysdate);
4898: ELSE
4899: CLOSE c_term_reas;