DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_INTERNAL dependencies on HR_ORGANIZATION_INFORMATION

Line 760: from hr_organization_information hoi

756: --
757: cursor c_get_ben_asgdets(p_business_group_id IN NUMBER)
758: Is
759: select substr(hoi.ORG_INFORMATION3,1)
760: from hr_organization_information hoi
761: where hoi.org_information_context = 'Benefits Defaults'
762: and hoi.organization_id = p_business_group_id
763: ;
764:

Line 765: l_ben_asg_status_flag hr_organization_information.ORG_INFORMATION3%type ;

761: where hoi.org_information_context = 'Benefits Defaults'
762: and hoi.organization_id = p_business_group_id
763: ;
764:
765: l_ben_asg_status_flag hr_organization_information.ORG_INFORMATION3%type ;
766: l_prev_per_id number;
767:
768: l_chk_flag varchar2(1) default 'N';
769: --