APPS.PQP_US_PENSION_EXTRACTS dependencies on DUAL

Line 477: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;

473: BEGIN
474:
475: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
476: g_conc_request_id := Fnd_Global.conc_request_id;
477: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
478: DELETE FROM pay_us_rpt_totals
479: WHERE organization_name = 'US Pension Extracts'
480: AND attribute30 = 'EXTRACT_COMPLETED'
481: AND organization_id = p_business_group_id

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

1890: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
1891: -- nocopy changes
1892: l_dtl_rec_nc := p_dtl_rec;
1893: -- Get the next sequence NUMBER to insert a record into the table
1894: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1895: INSERT INTO ben_ext_rslt_dtl
1896: (EXT_RSLT_DTL_ID
1897: ,EXT_RSLT_ID
1898: ,BUSINESS_GROUP_ID