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_POST_PROCESS dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 171: From Per_Spinal_POint_Placements_f Plcmt,

167: and Plip.Effective_End_Date;
168:
169: Cursor Step_Dtls Is
170: Select Plcmt.Step_id
171: From Per_Spinal_POint_Placements_f Plcmt,
172: Per_Spinal_point_Steps_F Step
173: Where Plcmt.Assignment_id = P_Assignment_Id
174: and P_Effective_Date
175: Between Plcmt.Effective_Start_Date

Line 801: From Per_Spinal_POint_Placements_f Plcmt,

797: and Plip.Effective_End_Date;
798:
799: Cursor Step_Dtls Is
800: Select Plcmt.Step_id, Step.Spinal_point_id, Plcmt.Effective_Start_Date
801: From Per_Spinal_POint_Placements_f Plcmt,
802: Per_Spinal_point_Steps_F Step
803: Where Plcmt.Assignment_id = P_Assignment_Id
804: and P_Effective_Date
805: Between Plcmt.Effective_Start_Date

Line 925: from per_spinal_point_placements_f

921: -- bug 8886934
922: cursor csr_max_step_date (p_asgid in number)
923: is
924: select max(Effective_Start_Date)
925: from per_spinal_point_placements_f
926: where assignment_id = p_asgid;
927:
928: l_sp_max_date date;
929:

Line 980: FROM per_spinal_point_placements_f plcmt

976:
977: AND steps.step_id IN
978: (
979: SELECT plcmt.step_id
980: FROM per_spinal_point_placements_f plcmt
981: WHERE p_effective_date between plcmt.effective_start_date AND plcmt.effective_end_date
982:
983: AND plcmt.assignment_id = p_assignment_id
984: )

Line 2471: from Per_Spinal_Point_Placements_F

2467:
2468: Cursor Plcmt_Dtls(P_Assignment_Id IN NUMBER, P_Effective_Date IN Date) is
2469: Select PLACEMENT_ID , Object_Version_Number,
2470: Effective_Start_Date, Effective_End_Date
2471: from Per_Spinal_Point_Placements_F
2472: Where Assignment_Id = P_Assignment_Id
2473: and P_Effective_Date
2474: Between Effective_Start_Date
2475: and Effective_End_Date;

Line 2490: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;

2486: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
2487: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
2488: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
2489: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2490: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2491: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2492: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2493: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2494: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;

Line 2491: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;

2487: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
2488: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
2489: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2490: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2491: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2492: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2493: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2494: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;
2495: l_group_name Varchar2(250);

Line 2492: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;

2488: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
2489: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2490: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2491: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2492: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2493: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2494: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;
2495: l_group_name Varchar2(250);
2496: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;

Line 2493: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;

2489: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2490: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2491: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2492: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2493: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2494: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;
2495: l_group_name Varchar2(250);
2496: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
2497: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;

Line 2594: ,P_BASE_TABLE_NAME => 'PER_SPINAL_POINT_PLACEMENTS_F'

2590: If Plcmt_Dtls%FOUND Then
2591:
2592: L_DATE_TRACK_MODE := DT_Mode
2593: (P_EFFECTIVE_DATE => Nvl(l_Enrt_Cvg_Strt_Dt, P_Effective_Date)
2594: ,P_BASE_TABLE_NAME => 'PER_SPINAL_POINT_PLACEMENTS_F'
2595: ,P_BASE_KEY_COLUMN => 'PLACEMENT_ID'
2596: ,P_BASE_KEY_VALUE => l_PLACEMENT_ID);
2597:
2598: /* Update Placements with the New Step Details */

Line 3127: From Per_Spinal_POint_Placements_f Plcmt,

3123:
3124: Cursor Step_Dtls
3125: Is
3126: Select Plcmt.Step_id, Step.Spinal_point_id
3127: From Per_Spinal_POint_Placements_f Plcmt,
3128: Per_Spinal_point_Steps_F Step
3129: Where Plcmt.Assignment_id = P_Assignment_Id
3130: and P_Effective_Date
3131: Between Plcmt.Effective_Start_Date