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_OPT_F

Line 194: From Ben_Opt_F

190: l_effective_date date;
191: Cursor Opts Is
192: Select Opt_id , Effective_Start_Date,
193: Effective_End_Date, Object_version_number
194: From Ben_Opt_F
195: Where MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'
196: and MAPPING_TABLE_PK_ID = p_spinal_point_id
197: and l_Effective_Date
198: between Effective_Start_Date and Effective_End_Date;

Line 209: L_Ovn_No Ben_Opt_F.Object_version_Number%TYPE;

205: from Ben_Pl_Typ_Opt_Typ_F
206: Where Opt_Id = P_Opt_id
207: and Pl_Typ_Opt_Typ_Cd = 'GSP';
208:
209: L_Ovn_No Ben_Opt_F.Object_version_Number%TYPE;
210: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;
211: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;
212: l_datetrack_mode varchar2(30);
213: l_eot date;

Line 210: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;

206: Where Opt_Id = P_Opt_id
207: and Pl_Typ_Opt_Typ_Cd = 'GSP';
208:
209: L_Ovn_No Ben_Opt_F.Object_version_Number%TYPE;
210: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;
211: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;
212: l_datetrack_mode varchar2(30);
213: l_eot date;
214:

Line 211: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;

207: and Pl_Typ_Opt_Typ_Cd = 'GSP';
208:
209: L_Ovn_No Ben_Opt_F.Object_version_Number%TYPE;
210: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;
211: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;
212: l_datetrack_mode varchar2(30);
213: l_eot date;
214:
215: l_Pl_Typ_Opt_Typ_Id Ben_Pl_Typ_Opt_Typ_F.Pl_Typ_Opt_Typ_Id%TYPE;

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 410: From ben_opt_f

406: l_effective_date date;
407:
408: Cursor csr_opt_exists is
409: Select opt_id
410: From ben_opt_f
411: Where mapping_table_name = 'PER_SPINAL_POINTS'
412: and mapping_table_pk_id = p_spinal_point_id;
413: --
414: --

Line 422: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;

418: Where opt_typ_cd = 'GSP'
419: and business_group_id = p_business_group_id
420: and l_effective_date between effective_start_date and effective_end_date;
421:
422: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;
423: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;
424: l_ovn_no ben_Opt_F.Object_Version_Number%TYPE;
425: L_opt_id ben_opt_F.Opt_Id%TYPE;
426: l_opt_exists varchar2(10);

Line 423: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;

419: and business_group_id = p_business_group_id
420: and l_effective_date between effective_start_date and effective_end_date;
421:
422: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;
423: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;
424: l_ovn_no ben_Opt_F.Object_Version_Number%TYPE;
425: L_opt_id ben_opt_F.Opt_Id%TYPE;
426: l_opt_exists varchar2(10);
427: --

Line 424: l_ovn_no ben_Opt_F.Object_Version_Number%TYPE;

420: and l_effective_date between effective_start_date and effective_end_date;
421:
422: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;
423: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;
424: l_ovn_no ben_Opt_F.Object_Version_Number%TYPE;
425: L_opt_id ben_opt_F.Opt_Id%TYPE;
426: l_opt_exists varchar2(10);
427: --
428: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

Line 425: L_opt_id ben_opt_F.Opt_Id%TYPE;

421:
422: L_Effective_Start_Date Ben_Opt_F.Effective_Start_Date%TYPE;
423: L_Effective_End_Date Ben_Opt_F.Effective_End_Date%TYPE;
424: l_ovn_no ben_Opt_F.Object_Version_Number%TYPE;
425: L_opt_id ben_opt_F.Opt_Id%TYPE;
426: l_opt_exists varchar2(10);
427: --
428: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
429: l_pl_typ_opt_typ_id ben_pl_typ_opt_typ_f.pl_typ_opt_typ_id%type;

Line 525: From Ben_Opt_F opt, Per_Spinal_POint_Steps_F Step

521:
522: Cursor Opt Is
523: Select opt.Opt_id , opt.Effective_Start_Date,
524: opt.Effective_End_Date,step.sequence ordr_num
525: From Ben_Opt_F opt, Per_Spinal_POint_Steps_F Step
526: Where Opt.MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'
527: and Opt.MAPPING_TABLE_PK_ID = p_spinal_point_id
528: and p_effective_date
529: between Opt.Effective_Start_Date and Opt.Effective_End_Date

Line 538: l_bg_id Ben_opt_F.Business_Group_id%TYPE;

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;
542: l_continue varchar2(30);