[Home] [Help]
272: END IF;
273: END IF;
274: IF p_org_info_type_code = 'DK_HOLIDAY_ENTITLEMENT_INFO' THEN
275:
276: select s.effective_date into l_effective_date from FND_SESSIONS s
277: where s.session_id = userenv('sessionid');
278:
279: l_hol_acc_sd := trunc(l_effective_date,'YEAR');
280: l_hol_acc_ed := last_day(trunc(l_effective_date,'YEAR'));
412:
413: END IF;
414: IF p_org_info_type_code = 'DK_HOLIDAY_ENTITLEMENT_INFO' THEN
415:
416: select s.effective_date into l_effective_date from FND_SESSIONS s
417: where s.session_id = userenv('sessionid');
418:
419: l_hol_acc_sd := trunc(l_effective_date,'YEAR');
420: l_hol_acc_ed := last_day(trunc(l_effective_date,'YEAR'));
553:
554: SP_DATA_FOUND EXCEPTION;
555:
556: cursor orgtype is
557: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
558: where ou.organization_id= p_organization_id
559: and s.session_id = userenv('sessionid')
560: and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
561:
565: CURSOR get_sp( p_business_group_id hr_organization_units.business_group_id%TYPE) IS
566: select count(hou.organization_id)
567: from HR_ORGANIZATION_INFORMATION hoi
568: ,HR_ORGANIZATION_UNITS hou
569: ,FND_SESSIONS s
570: where hoi.org_information_context ='CLASS'
571: and hoi.org_information1 ='DK_SERVICE_PROVIDER'
572: and hou.organization_id = hoi.organization_id
573: and hou.BUSINESS_GROUP_ID = p_business_group_id