DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on FND_PROFILE

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

1364: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
1365: AND (NVL(CURRENT_EMPLOYEE_FLAG,'N') = 'Y'
1366: OR NVL(CURRENT_NPW_FLAG,'N') = 'Y')
1367: AND a.assignment_type in ('E',decode(
1368: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N'),'Y','C','E'))
1369: AND a.assignment_status_type_id = past.assignment_status_type_id
1370: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN','ACTIVE_CWK')
1371: AND poeh.position_structure_id = p_path_id
1372: AND poeh.employee_id = p_emp_id

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

1430: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
1431: AND (NVL(CURRENT_EMPLOYEE_FLAG,'N') = 'Y'
1432: OR NVL(CURRENT_NPW_FLAG,'N') = 'Y')
1433: AND a.assignment_type in ('E',decode(
1434: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N'),'Y','C','E'))
1435: AND a.assignment_status_type_id = past.assignment_status_type_id
1436: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN','ACTIVE_CWK')
1437: AND poeh.position_structure_id = p_path_id
1438: AND poeh.employee_id = p_emp_id