DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_INTERNAL dependencies on HR_ORGANIZATION_INFORMATION

Line 554: from hr_organization_information hoi

550: --
551: cursor c_get_ben_asgdets(p_business_group_id IN NUMBER)
552: Is
553: select substr(hoi.ORG_INFORMATION3,1)
554: from hr_organization_information hoi
555: where hoi.org_information_context = 'Benefits Defaults'
556: and hoi.organization_id = p_business_group_id
557: ;
558:

Line 559: l_ben_asg_status_flag hr_organization_information.ORG_INFORMATION3%type ;

555: where hoi.org_information_context = 'Benefits Defaults'
556: and hoi.organization_id = p_business_group_id
557: ;
558:
559: l_ben_asg_status_flag hr_organization_information.ORG_INFORMATION3%type ;
560: l_prev_per_id number;
561: --
562: procedure copy_emppradd_ctrpradd
563: (p_empper_id in number