APPS.HR_DK_VALIDATE_PKG dependencies on FND_SESSIONS

Line 508: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s

504:
505: SP_DATA_FOUND EXCEPTION;
506:
507: cursor orgtype is
508: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
509: where ou.organization_id= p_organization_id
510: and s.session_id = userenv('sessionid')
511: and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
512:

Line 520: ,FND_SESSIONS s

516: CURSOR get_sp( p_business_group_id hr_organization_units.business_group_id%TYPE) IS
517: select count(hou.organization_id)
518: from HR_ORGANIZATION_INFORMATION hoi
519: ,HR_ORGANIZATION_UNITS hou
520: ,FND_SESSIONS s
521: where hoi.org_information_context ='CLASS'
522: and hoi.org_information1 ='DK_SERVICE_PROVIDER'
523: and hou.organization_id = hoi.organization_id
524: and hou.BUSINESS_GROUP_ID = p_business_group_id