eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_US_NFC_EXTRACTS dependencies on DUAL

Line 82: -- Cursor to check has a valid Processed Individual Award within

78: WHERE bba.pl_id = c_ext_rslt_id
79: AND bba.pgm_id = c_ext_dfn_id
80: AND bba.business_group_id = c_business_group_id;
81:
82: -- Cursor to check has a valid Processed Individual Award within
83: -- the extract date range
84: CURSOR csr_ghr_awd (c_person_id in number
85: ,c_assignment_id in number
86: ,c_ext_start_date in date

Line 4667: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;

4663: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
4664: -- nocopy changes
4665: l_dtl_rec_nc := p_dtl_rec;
4666: -- Get the next sequence NUMBER to insert a record into the table
4667: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;
4668: insert into ben_ext_rslt_dtl
4669: (ext_rslt_dtl_id
4670: ,ext_rslt_id
4671: ,business_group_id