APPS.PQP_PENSION_EXTRACTS dependencies on DUAL

Line 676: SELECT USERENV('SESSIONID') INTO l_session_id FROM dual;

672: g_debug := hr_utility.debug_enabled;
673:
674: hr_utility.set_location('Entering: '||l_proc_name, 5);
675: g_conc_request_id := fnd_global.conc_request_id;
676: SELECT USERENV('SESSIONID') INTO l_session_id FROM dual;
677: DELETE FROM pay_us_rpt_totals
678: WHERE organization_name = 'Global Pension Extracts'
679: AND attribute30 = 'EXTRACT_COMPLETED'
680: AND business_group_id = p_business_group_id

Line 1080: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;

1076: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
1077: l_dtl_rec_nc := p_dtl_rec;
1078:
1079: -- Get the next sequence NUMBER to insert a record into the table
1080: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1081: INSERT INTO ben_ext_rslt_dtl
1082: (ext_rslt_dtl_id
1083: ,ext_rslt_id
1084: ,business_group_id