DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on DUAL

Line 388: from sys.dual;

384:
385: -- copied from peper01t.pkb ( bug 1368672 )
386: --
387: cursor c1 is select per_people_s.nextval
388: from sys.dual;
389: --
390: --
391: -- Retrieve the person type id if the applicant is terminated
392: function get_ex_apl_person_type_id ( p_business_group_id in number )

Line 2183: FROM SYS.DUAL

2179: l_proc varchar2(31) := 'exists_val_grd_for_pos_and_job';
2180: --
2181: cursor c1 is
2182: SELECT 1
2183: FROM SYS.DUAL
2184: WHERE EXISTS
2185: (SELECT NULL
2186: FROM PER_VALID_GRADES
2187: WHERE business_group_id + 0 = p_business_group_id

Line 2195: FROM SYS.DUAL

2191: AND JOB_ID = p_job_id ) ;
2192: --
2193: cursor c2 is
2194: SELECT 1
2195: FROM SYS.DUAL
2196: WHERE EXISTS
2197: (SELECT NULL
2198: FROM PER_VALID_GRADES
2199: WHERE business_group_id + 0 = p_business_group_id