DBA Data[Home] [Help]

APPS.HR_NI_CHK_PKG dependencies on DUAL

Line 556: FROM sys.dual

552: */
553: if l_legislation_code = 'GB' then
554: SELECT 'Y'
555: INTO l_status
556: FROM sys.dual
557: WHERE exists(SELECT '1'
558: FROM per_all_people_f pp
559: WHERE (p_person_id IS NULL
560: OR p_person_id <> pp.person_id)

Line 566: FROM sys.dual

562: AND pp.business_group_id +0 = p_business_group_id);
563: else
564: SELECT 'Y'
565: INTO l_status
566: FROM sys.dual
567: WHERE exists(SELECT '1'
568: FROM per_all_people_f pp
569: WHERE (p_person_id IS NULL
570: OR p_person_id <> pp.person_id)