APPS.PO_APPROVALLIST_S1 dependencies on FND_PROFILE

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

493: WHERE poeh.position_structure_id = p_approval_path_id
494: AND poeh.employee_id = p_employee_id
495: AND cwk.person_id = poeh.superior_id
496: AND poeh.superior_level > 0
497: AND nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y'
498: ORDER BY superior_level, full_name;
499:
500: --Changes Made For Bug 2605927. Added new variables.
501:

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

2179: p_approver_id IN NUMBER,
2180: p_approver_type IN VARCHAR2) RETURN BOOLEAN IS
2181: l_profile_value VARCHAR2(240) := NULL;
2182: BEGIN
2183: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_profile_value);
2184: RETURN (p_approver_type = 'SYSTEM' AND (l_profile_value IS NULL OR l_profile_value = 'Y'));
2185: END is_approver_mandatory;
2186:
2187: