DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on HR_GENERAL

Line 396: AND Decode(hr_general.get_xbg_profile,'Y',p.business_group_id,

392: AND TRUNC(SYSDATE) BETWEEN P.effective_start_date AND P.effective_end_date
393: AND TRUNC(SYSDATE) BETWEEN A.effective_start_date AND A.effective_end_date
394: AND (NVL(current_employee_flag,'N') = 'Y'
395: OR NVL(current_npw_flag,'N') = 'Y')
396: AND Decode(hr_general.get_xbg_profile,'Y',p.business_group_id,
397: l_fsp_business_group_id) = p.business_group_id /* 9034751 */ AND A.assignment_type IN ('E',l_assignment_type));
398:
399: IF (SQL%ROWCOUNT > 0) THEN
400: x_result_type := po_validations.c_result_type_failure;