APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on FND_PROFILE

Line 5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

1: PACKAGE BODY PO_REQAPPROVAL_FINDAPPRV1 AS
2: /* $Header: POXWPA3B.pls 120.9.12020000.2 2013/02/10 19:28:13 vegajula ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7:
8: /*=======================================================================+
9: | FILENAME

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

2021: WHERE poeh.position_structure_id = p_approval_path_id
2022: AND poeh.employee_id = p_empid
2023: AND cwk.person_id = poeh.superior_id
2024: AND poeh.superior_level > 0
2025: AND nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y'
2026: AND A.PERSON_ID = CWK.PERSON_ID
2027: AND A.PERSON_ID = PS.PERSON_ID
2028: AND A.ASSIGNMENT_TYPE='E'
2029: AND CWK.EMPLOYEE_NUMBER IS NOT NULL

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

2042: WHERE poeh.position_structure_id = p_approval_path_id
2043: AND poeh.employee_id = p_empid
2044: AND cwk.person_id = poeh.superior_id
2045: AND poeh.superior_level > 0
2046: AND nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y'
2047: AND A.PERSON_ID = CWK.PERSON_ID
2048: AND A.PERSON_ID = PP.PERSON_ID
2049: AND A.ASSIGNMENT_TYPE='C'
2050: AND CWK.NPW_NUMBER IS NOT NULL