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 PER_SPINAL_POINTS

Line 195: Where MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'

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;
199:

Line 287: Where Opt.MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'

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
291: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'

Line 411: Where mapping_table_name = 'PER_SPINAL_POINTS'

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: --
415: Cursor get_pl_typ is

Line 474: ,P_MAPPING_TABLE_NAME => 'PER_SPINAL_POINTS'

470: ,P_EFFECTIVE_END_DATE => L_Effective_End_Date
471: ,P_NAME => p_pay_scale_name||':'||p_spinal_point_name
472: ,P_BUSINESS_GROUP_ID => p_Business_Group_id
473: ,P_OBJECT_VERSION_NUMBER => l_ovn_no
474: ,P_MAPPING_TABLE_NAME => 'PER_SPINAL_POINTS'
475: ,P_MAPPING_TABLE_PK_ID => P_Spinal_point_Id
476: ,P_EFFECTIVE_DATE => l_effective_date );
477: --
478: -- Also create plan type option type link.

Line 518: from per_spinal_points psp, per_parent_spines pps

514: and p_effective_date between Effective_Start_Date and Effective_End_Date;
515:
516: cursor point is
517: select psp.spinal_point_id spinal_point_id,psp.spinal_point spinal_point,pps.name scale_name
518: from per_spinal_points psp, per_parent_spines pps
519: where psp.spinal_point_id = p_spinal_point_id
520: and psp.parent_spine_id = pps.parent_spine_id;
521:
522: Cursor Opt Is

Line 526: Where Opt.MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'

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
530: and Step.Step_id = P_Step_id