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.PQP_NL_PENSION_EXTRACTS dependencies on DUAL

Line 1155: FROM dual;

1151: CURSOR c_get_retro_date_earned(c_element_entry_id in number) IS
1152: SELECT substr(fnd_date.date_to_canonical(
1153: trunc(pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id))
1154: ),1,10)
1155: FROM dual;
1156:
1157: TYPE r_rec_retro_ptp IS RECORD
1158: (start_date Date
1159: ,end_date Date

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

1262: Fnd_Message.set_name('PQP','PQP_230869_END_BEFORE_START');
1263: Fnd_Message.raise_error;
1264: END IF;
1265:
1266: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
1267:
1268: -- Delete values from the temporary table
1269: DELETE FROM pay_us_rpt_totals
1270: WHERE organization_name = 'NL ABP Pension Extracts';

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

1569: END IF;
1570: -- nocopy changes
1571: l_dtl_rec_nc := p_dtl_rec;
1572: -- Get the next sequence NUMBER to insert a record into the table
1573: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1574:
1575: INSERT INTO ben_ext_rslt_dtl
1576: (EXT_RSLT_DTL_ID
1577: ,EXT_RSLT_ID

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

7044: CLOSE cur_get_postal_code;
7045: IF l_postal_code IS NOT NULL THEN
7046: FOR i in 1..length(l_postal_code)
7047: LOOP
7048: SELECT substr(l_postal_code,i,1) INTO temp_str from dual;
7049: IF temp_str <> ' ' THEN
7050: l_postal_code1 := l_postal_code1||temp_str;
7051: END IF;
7052: END LOOP;

Line 7502: FROM dual ;

7498: AND asg.assignment_id = c_assign_id;
7499:
7500: CURSOR cur_get_yr(c_effective_dt IN Date) IS
7501: SELECT fnd_date.canonical_to_date(TO_CHAR(c_effective_dt,'YYYY')||'/01/01')
7502: FROM dual ;
7503: --
7504: -- Cursor to check if there are any changes in the pension salary
7505: --
7506: CURSOR c_get_override_start_date IS

Line 8553: FROM dual;

8549: -- Cursor to fetch the month for the effective date
8550: --
8551: CURSOR c_get_month IS
8552: SELECT TO_CHAR(p_effective_date,'MM')
8553: FROM dual;
8554: --
8555: -- Cursor to check if Rec 08 was sent to ABP in the current year.
8556: -- fot this assignment . If not sent then trigger a send
8557: --

Line 10037: Individual Schemes Code

10033: --
10034: -- Logic behind the code
10035: --
10036: /*
10037: Individual Schemes Code
10038: ============================= ======
10039: No Participation G
10040: FPU Standard (End 31-DEC-03) S
10041: FPU Extra C

Line 12634: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;

12630: ,p_effective_date
12631: ,p_error_message
12632: ,l_seq_num);
12633:
12634: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;
12635:
12636: INSERT INTO ben_ext_rslt_dtl
12637: ( EXT_RSLT_DTL_ID
12638: ,EXT_RSLT_ID

Line 12737: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;

12733: ,c_ext_dtl_rcd_id => l_rcd_id);
12734: FETCH csr_rslt_dtl INTO l_main_rec;
12735: CLOSE csr_rslt_dtl;
12736:
12737: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;
12738:
12739: INSERT INTO ben_ext_rslt_dtl
12740: ( EXT_RSLT_DTL_ID
12741: ,EXT_RSLT_ID

Line 13874: FROM dual;

13870:
13871: --cursor to fetch the month from the effective date
13872: CURSOR c_get_amt_month IS
13873: SELECT To_Char(p_effective_date,'MM')
13874: FROM dual;
13875:
13876: BEGIN
13877: Hr_Utility.set_location('Entering:-------- '||l_proc_name, 5);
13878: OPEN c_get_amt_month;

Line 13913: FROM dual;

13909: --Cursor to fetch the year from the effective date
13910: --
13911: CURSOR c_get_amt_year IS
13912: SELECT TO_CHAR(p_effective_date,'YYYY')
13913: FROM dual;
13914:
13915: BEGIN
13916:
13917: hr_utility.set_location('Entering :------- '||l_proc_name,5);

Line 15859: ELSIF (p_data_element_cd = 'OPNP_INDIVIDUAL_CD') THEN

15855: ,p_date_earned
15856: ,p_error_message
15857: ,p_data_element_value);
15858:
15859: ELSIF (p_data_element_cd = 'OPNP_INDIVIDUAL_CD') THEN
15860:
15861: l_ret_val := Get_rec05_Participation
15862: (p_assignment_id
15863: ,p_business_group_id

Line 16204: FROM dual;

16200: ) RETURN Varchar2 IS
16201:
16202: CURSOR csr_get_sign(c_amount IN Number) IS
16203: SELECT Sign(c_amount)
16204: FROM dual;
16205:
16206: l_proc_name Varchar2(150) := g_proc_name ||'.Get_Trailer_Amount_Sign';
16207: l_sing_number Number := 0;
16208: l_temp Number;

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

16611: (c_org_id => g_employer_child_list(l_group_org_index).gre_org_id
16612: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
16613: LOOP
16614: --Hr_Utility.set_location('val'||val.EXT_RSLT_DTL_ID ,26);
16615: -- Get the individual row using sortid key
16616: -- So we will get only one record related data per person
16617: FOR ind_dtl IN csr_rslt_dtl_sort
16618: (c_val_26 => val.val_26
16619: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

Line 16769: END LOOP ; --individual close

16765: END IF;
16766: END IF;
16767: END IF;
16768: --End of 99 Processing
16769: END LOOP ; --individual close
16770: END LOOP;--End of val result loop
16771:
16772: --Get the record count for 20,21 and 22
16773: l_record94_count:=l_record94_count + Get_Trailer_Record_Count(g_rcd_dtls(20).ext_rcd_id