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.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on BEN_OIPL_F

Line 286: From Ben_Oipl_F Oipl, Ben_Opt_F opt, Ben_pl_F Pl

282:
283: Cursor Oipl Is
284: Select Oipl.Oipl_id , Oipl.Effective_Start_Date,
285: Oipl.Effective_End_Date, Oipl.Object_version_number
286: From Ben_Oipl_F Oipl, Ben_Opt_F opt, Ben_pl_F Pl
287: Where Opt.MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'
288: and Opt.MAPPING_TABLE_PK_ID = p_spinal_point_id
289: and p_effective_date
290: between Opt.Effective_Start_Date and Opt.Effective_End_Date

Line 300: L_Effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;

296: and Pl.Pl_Id = Oipl.Pl_Id
297: and p_effective_date
298: between Oipl.Effective_Start_Date and Oipl.Effective_End_Date;
299:
300: L_Effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;
301: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;
302: l_Object_version_Number Ben_Oipl_F.Object_version_Number%TYPE;
303:
304: Begin

Line 301: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;

297: and p_effective_date
298: between Oipl.Effective_Start_Date and Oipl.Effective_End_Date;
299:
300: L_Effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;
301: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;
302: l_Object_version_Number Ben_Oipl_F.Object_version_Number%TYPE;
303:
304: Begin
305: --

Line 302: l_Object_version_Number Ben_Oipl_F.Object_version_Number%TYPE;

298: between Oipl.Effective_Start_Date and Oipl.Effective_End_Date;
299:
300: L_Effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;
301: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;
302: l_Object_version_Number Ben_Oipl_F.Object_version_Number%TYPE;
303:
304: Begin
305: --
306: -- 1. Find the option in plan record corresponding to the step.

Line 345: from ben_oipl_f

341: if p_pl_id is not null and p_opt_id is not null then
342: begin
343: select oipl_id
344: into l_oipl_id
345: from ben_oipl_f
346: where pl_id = p_pl_id
347: and opt_id = p_opt_id
348: and p_effective_date between effective_start_date and effective_end_date;
349: hr_utility.set_location('oipl is '||l_oipl_id,30);

Line 376: from ben_oipl_f

372: if p_pl_id is not null and p_opt_id is not null then
373: begin
374: select max(ordr_num)
375: into l_max_seq
376: from ben_oipl_f
377: where pl_id = p_pl_id
378: and p_effective_date between effective_start_date and effective_end_date;
379: hr_utility.set_location('max seq is '||l_max_seq,10);
380: l_max_seq := nvl(l_max_seq,0) + 1;

Line 535: l_Oipl_id Ben_oipl_f.oipl_Id%TYPE;

531: and p_effective_date
532: between Step.Effective_Start_Date and Step.Effective_End_Date
533: and Step.Spinal_Point_id = p_spinal_point_id;
534:
535: l_Oipl_id Ben_oipl_f.oipl_Id%TYPE;
536: l_effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;
537: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;
538: l_bg_id Ben_opt_F.Business_Group_id%TYPE;
539: l_ovn_no ben_oipl_f.Object_Version_Number%TYPE;

Line 536: l_effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;

532: between Step.Effective_Start_Date and Step.Effective_End_Date
533: and Step.Spinal_Point_id = p_spinal_point_id;
534:
535: l_Oipl_id Ben_oipl_f.oipl_Id%TYPE;
536: l_effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;
537: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;
538: l_bg_id Ben_opt_F.Business_Group_id%TYPE;
539: l_ovn_no ben_oipl_f.Object_Version_Number%TYPE;
540: l_oipl_exists boolean;

Line 537: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;

533: and Step.Spinal_Point_id = p_spinal_point_id;
534:
535: l_Oipl_id Ben_oipl_f.oipl_Id%TYPE;
536: l_effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;
537: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;
538: l_bg_id Ben_opt_F.Business_Group_id%TYPE;
539: l_ovn_no ben_oipl_f.Object_Version_Number%TYPE;
540: l_oipl_exists boolean;
541: l_max_oipl_seq number;

Line 539: l_ovn_no ben_oipl_f.Object_Version_Number%TYPE;

535: l_Oipl_id Ben_oipl_f.oipl_Id%TYPE;
536: l_effective_Start_Date Ben_Oipl_F.Effective_Start_Date%TYPE;
537: L_Effective_End_Date Ben_Oipl_F.Effective_End_Date%TYPE;
538: l_bg_id Ben_opt_F.Business_Group_id%TYPE;
539: l_ovn_no ben_oipl_f.Object_Version_Number%TYPE;
540: l_oipl_exists boolean;
541: l_max_oipl_seq number;
542: l_continue varchar2(30);
543: Begin