APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on DUAL

Line 494: FROM sys.dual

490: -- cursor to check criteria type valid
491: --
492: CURSOR csr_chk_criteria_type IS
493: SELECT 'error'
494: FROM sys.dual
495: WHERE EXISTS (
496: SELECT 'x'
497: FROM hr_lookups h
498: WHERE h.lookup_type = 'HXC_TK_CRITERIA_TYPES'

Line 568: FROM dual

564: l_dummy varchar2(1);
565:
566: CURSOR csr_chk_assignment_id IS
567: SELECT 'x'
568: FROM dual
569: WHERE EXISTS ( select 'x'
570: FROM per_assignments_f asg
571: WHERE asg.assignment_id = p_criteria_id );
572: -- GAZ - anymore specific ????

Line 576: FROM dual

572: -- GAZ - anymore specific ????
573:
574: CURSOR csr_chk_person_id IS
575: SELECT 'x'
576: FROM dual
577: WHERE EXISTS ( select 'x'
578: FROM per_people_f p
579: WHERE p.person_id = p_criteria_id );
580: -- GAZ - anymore specific ????

Line 634: FROM dual

630: l_dummy varchar2(1) := NULL;
631:
632: CURSOR csr_chk_tk_group_query_id IS
633: SELECT 'x'
634: FROM dual
635: WHERE EXISTS ( SELECT 'x'
636: FROM hxc_tk_group_queries tkgq
637: WHERE tkgq.tk_group_query_id = p_tk_group_query_id );
638:

Line 805: FROM sys.dual

801: , p_criteria_id number ) IS
802:
803: CURSOR csr_chk_unique IS
804: SELECT 'x'
805: FROM sys.dual
806: WHERE EXISTS (
807: SELECT 'x'
808: FROM hxc_tk_group_query_criteria tkgqc
809: WHERE tkgqc.tk_group_query_id = p_tk_group_query_id