DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on FND_PROFILE

Line 1359: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N'),'Y','C','E'))

1355: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
1356: AND (NVL(CURRENT_EMPLOYEE_FLAG,'N') = 'Y'
1357: OR NVL(CURRENT_NPW_FLAG,'N') = 'Y')
1358: AND a.assignment_type in ('E',decode(
1359: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N'),'Y','C','E'))
1360: AND a.assignment_status_type_id = past.assignment_status_type_id
1361: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
1362: AND poeh.position_structure_id = p_path_id
1363: AND poeh.employee_id = p_emp_id

Line 1425: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N'),'Y','C','E'))

1421: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
1422: AND (NVL(CURRENT_EMPLOYEE_FLAG,'N') = 'Y'
1423: OR NVL(CURRENT_NPW_FLAG,'N') = 'Y')
1424: AND a.assignment_type in ('E',decode(
1425: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N'),'Y','C','E'))
1426: AND a.assignment_status_type_id = past.assignment_status_type_id
1427: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
1428: AND poeh.position_structure_id = p_path_id
1429: AND poeh.employee_id = p_emp_id