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 760: From Per_Spinal_POint_Placements_f Plcmt,

756: and Plip.Effective_End_Date;
757:
758: Cursor Step_Dtls Is
759: Select Plcmt.Step_id, Step.Spinal_point_id, Plcmt.Effective_Start_Date
760: From Per_Spinal_POint_Placements_f Plcmt,
761: Per_Spinal_point_Steps_F Step
762: Where Plcmt.Assignment_id = P_Assignment_Id
763: and P_Effective_Date
764: Between Plcmt.Effective_Start_Date

Line 2311: from Per_Spinal_Point_Placements_F

2307:
2308: Cursor Plcmt_Dtls(P_Assignment_Id IN NUMBER, P_Effective_Date IN Date) is
2309: Select PLACEMENT_ID , Object_Version_Number,
2310: Effective_Start_Date, Effective_End_Date
2311: from Per_Spinal_Point_Placements_F
2312: Where Assignment_Id = P_Assignment_Id
2313: and P_Effective_Date
2314: Between Effective_Start_Date
2315: and Effective_End_Date;

Line 2330: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;

2326: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
2327: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
2328: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
2329: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2330: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2331: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2332: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2333: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2334: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;

Line 2331: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;

2327: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
2328: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
2329: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2330: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2331: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2332: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2333: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2334: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;
2335: l_group_name Varchar2(250);

Line 2332: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;

2328: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
2329: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2330: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2331: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2332: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2333: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2334: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;
2335: l_group_name Varchar2(250);
2336: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;

Line 2333: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;

2329: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
2330: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2331: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2332: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2333: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2334: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;
2335: l_group_name Varchar2(250);
2336: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
2337: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;

Line 2434: ,P_BASE_TABLE_NAME => 'PER_SPINAL_POINT_PLACEMENTS_F'

2430: If Plcmt_Dtls%FOUND Then
2431:
2432: L_DATE_TRACK_MODE := DT_Mode
2433: (P_EFFECTIVE_DATE => Nvl(l_Enrt_Cvg_Strt_Dt, P_Effective_Date)
2434: ,P_BASE_TABLE_NAME => 'PER_SPINAL_POINT_PLACEMENTS_F'
2435: ,P_BASE_KEY_COLUMN => 'PLACEMENT_ID'
2436: ,P_BASE_KEY_VALUE => l_PLACEMENT_ID);
2437:
2438: /* Update Placements with the New Step Details */

Line 2967: From Per_Spinal_POint_Placements_f Plcmt,

2963:
2964: Cursor Step_Dtls
2965: Is
2966: Select Plcmt.Step_id, Step.Spinal_point_id
2967: From Per_Spinal_POint_Placements_f Plcmt,
2968: Per_Spinal_point_Steps_F Step
2969: Where Plcmt.Assignment_id = P_Assignment_Id
2970: and P_Effective_Date
2971: Between Plcmt.Effective_Start_Date