APPS.PO_APPROVALLIST_S1 dependencies on FND_PROFILE

Line 514: AND nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y'

510: WHERE poeh.position_structure_id = p_approval_path_id
511: AND poeh.employee_id = p_employee_id
512: AND cwk.person_id = poeh.superior_id
513: AND poeh.superior_level > 0
514: AND nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y'
515: ORDER BY superior_level, full_name;
516:
517: --Changes Made For Bug 2605927. Added new variables.
518:

Line 2295: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_profile_value);

2291: p_approver_id IN NUMBER,
2292: p_approver_type IN VARCHAR2) RETURN BOOLEAN IS
2293: l_profile_value VARCHAR2(240) := NULL;
2294: BEGIN
2295: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_profile_value);
2296: RETURN (p_approver_type = 'SYSTEM' AND (l_profile_value IS NULL OR l_profile_value = 'Y'));
2297: END is_approver_mandatory;
2298:
2299: