APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on DUAL

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

709: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
710: -- nocopy changes
711: l_dtl_rec_nc := p_dtl_rec;
712: -- Get the next sequence NUMBER to insert a record into the table
713: SELECT ben_ext_rslt_dtl_s .NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
714: hr_utility.set_location(p_dtl_rec.EXT_RSLT_DTL_ID,10);
715: hr_utility.set_location(p_dtl_rec.EXT_RSLT_ID,10);
716: hr_utility.set_location(p_dtl_rec.BUSINESS_GROUP_ID,10);
717: hr_utility.set_location(p_dtl_rec.EXT_RCD_ID,10);

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

1812: Fnd_Message.set_name('PQP','PQP_230869_END_BEFORE_START');
1813: Fnd_Message.raise_error;
1814: END IF;
1815:
1816: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
1817:
1818: -- Delete values from the temporary table
1819: DELETE FROM pay_us_rpt_totals
1820: WHERE organization_name = 'NL PGGM Pension Extracts';

Line 3007: SELECT substr(l_postal_code,i,1) INTO temp_str from dual;

3003: IF cur_get_postal_code%FOUND THEN
3004: CLOSE cur_get_postal_code;
3005: FOR i in 1..length(l_postal_code)
3006: LOOP
3007: SELECT substr(l_postal_code,i,1) INTO temp_str from dual;
3008: IF temp_str <> ' ' THEN
3009: l_postal_code1 := l_postal_code1||temp_str;
3010: END IF;
3011: END LOOP;

Line 7976: -- Get the individual row using sortid key

7972: FOR val IN csr_get_rslt
7973: (c_org_id => g_ord_details(num).gre_org_id
7974: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
7975: LOOP
7976: -- Get the individual row using sortid key
7977: -- So we will get only one record related data per person
7978: FOR ind_dtl IN csr_rslt_dtl_sort
7979: (c_val_32=> val.val_32
7980: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id