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_ALL_ASSIGNMENTS_F

Line 113: l_Grade_id Per_all_Assignments_F.Grade_Id%TYPE;

109: l_Person_name Per_All_People_F.Full_name%TYPE;
110: l_Person_Id Per_All_People_F.Person_Id%TYPE;
111: l_Last_Name Per_All_People_F.Last_name%TYPE;
112: L_Cnt Number;
113: l_Grade_id Per_all_Assignments_F.Grade_Id%TYPE;
114: l_Dflt_Step_Cd Ben_Pgm_F.Dflt_Step_Cd%TYPE;
115: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
116: l_Mass_update_Call Varchar2(1) := 'N';
117: l_Last_Per_In_ler_Id Ben_Per_In_ler.Per_in_ler_Id%TYPE;

Line 123: from Per_All_Assignments_F Asgt,

119: l_Le_Exists Varchar2(1);
120:
121: Cursor Person_Dtls is
122: Select Full_name, Last_NAME, Person.Person_Id, Asgt.Grade_id, Asgt.Grade_Ladder_Pgm_Id
123: from Per_All_Assignments_F Asgt,
124: PER_ASSIGNMENT_STATUS_TYPES Pas,
125: Per_All_People_F Person
126: Where Assignment_Id = P_Assignment_Id
127: and P_Effective_Date

Line 404: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;

400: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
401: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
402: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
403: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
404: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;
405:
406: l_PROCD_DT DATE;
407: l_STRTD_DT DATE;
408: l_VOIDD_DT Date;

Line 508: from Per_All_Assignments_F Paa

504: Cursor Asgt_Dtls
505: Is
506: Select Paa.Assignment_Id, Paa.Grade_ladder_Pgm_Id, Paa.Grade_Id, Paa.Person_Id,
507: paa.soft_coding_keyflex_id,paa.people_group_id,paa.special_ceiling_step_id,paa.object_version_number
508: from Per_All_Assignments_F Paa
509: Where L_Effective_Date Between paa.Effective_Start_Date and Paa.Effective_End_Date
510: and Paa.Business_group_id = hr_General.get_Business_group_id
511: and Paa.Person_id = Nvl(P_Person_Id, Paa.Person_Id)
512: and paa.assignment_type ='E'

Line 531: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;

527: L_Cnt Number := 0;
528: L_Error_Exists Varchar2(1) := 'N';
529: l_conc_status boolean;
530:
531: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
532: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
533: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
534: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;

Line 532: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;

528: L_Error_Exists Varchar2(1) := 'N';
529: l_conc_status boolean;
530:
531: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
532: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
533: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
534: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
536: L_DATE_TRACK_MODE Varchar2(25);

Line 533: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;

529: l_conc_status boolean;
530:
531: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
532: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
533: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
534: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
536: L_DATE_TRACK_MODE Varchar2(25);
537: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;

Line 534: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;

530:
531: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
532: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
533: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
534: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
536: L_DATE_TRACK_MODE Varchar2(25);
537: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
538: l_group_name Varchar2(250);

Line 537: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;

533: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
534: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
536: L_DATE_TRACK_MODE Varchar2(25);
537: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
538: l_group_name Varchar2(250);
539: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
540: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;
541: l_org_now_no_manager_warning Boolean;

Line 539: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;

535: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
536: L_DATE_TRACK_MODE Varchar2(25);
537: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
538: l_group_name Varchar2(250);
539: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
540: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;
541: l_org_now_no_manager_warning Boolean;
542: l_other_manager_warning Boolean;
543: l_spp_delete_warning Boolean;

Line 540: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;

536: L_DATE_TRACK_MODE Varchar2(25);
537: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
538: l_group_name Varchar2(250);
539: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
540: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;
541: l_org_now_no_manager_warning Boolean;
542: l_other_manager_warning Boolean;
543: l_spp_delete_warning Boolean;
544: l_entries_changed_warning Varchar2(250);

Line 625: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'

621: if l_person_rule_checked then
622:
623: L_DATE_TRACK_MODE := pqh_gsp_post_process.DT_Mode
624: (P_EFFECTIVE_DATE => L_Effective_Date
625: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'
626: ,P_BASE_KEY_COLUMN => 'ASSIGNMENT_ID'
627: ,P_BASE_KEY_VALUE => L_Assignment_id);
628: hr_utility.set_location('L_date_track_mode:'||L_DATE_TRACK_MODE,90);
629: IF l_date_track_mode = 'CORRECTION' OR l_date_track_mode = 'UPDATE' THEN

Line 731: from Per_All_Assignments_f Asgt

727:
728: Cursor Person_Info Is
729: Select Asgt.Person_Id, Asgt.Business_Group_id,
730: Asgt.Grade_Id , Asgt.pay_basis_id, Asgt.GRADE_LADDER_PGM_ID, Asgt.Effective_Start_Date
731: from Per_All_Assignments_f Asgt
732: Where Assignment_Id = P_Assignment_Id
733: and P_Effective_Date
734: Between Asgt.Effective_Start_Date
735: and Asgt.Effective_End_Date;

Line 872: from per_all_assignments_f

868:
869: Cursor Csr_prev_assignment(P_Person_Id in Number,p_max_lf_evt_date in date)
870: IS
871: select assignment_id
872: from per_all_assignments_f
873: where person_id = p_person_id
874: and assignment_type ='E'
875: and primary_flag ='Y'
876: and p_max_lf_evt_date

Line 916: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;

912: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
913: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
914: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
915: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
916: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
917: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;
918: l_Grade_Id Per_Grades.Grade_Id%TYPE;
919: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
920: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;

Line 917: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;

913: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
914: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
915: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
916: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
917: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;
918: l_Grade_Id Per_Grades.Grade_Id%TYPE;
919: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
920: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
921: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;

Line 1768: Per_All_Assignments_F Asgt

1764: Rate.pk_Id , Rate.Object_Version_Number, Enrt.Pgm_Id,
1765: Asgt.Assignment_Id, Asgt.pay_basis_id, Enrt.Business_Group_id
1766: From Ben_PRTT_ENRT_RSLT_F Enrt,
1767: ben_prtt_rt_val Rate,
1768: Per_All_Assignments_F Asgt
1769: Where Enrt.PRTT_ENRT_RSLT_ID = P_PRTT_ENRT_RSLT_ID
1770: and P_Effective_Date
1771: between Enrt.Effective_Start_Date
1772: and Enrt.Effective_End_Date

Line 1815: Per_All_Assignments_F Asgt

1811: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id
1812: From Ben_ELig_per_Elctbl_Chc Enrt,
1813: ben_Enrt_Rt Rate,
1814: Ben_Per_in_ler PIL,
1815: Per_All_Assignments_F Asgt
1816: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1817: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id
1818: And Asgt.Person_id = PIL.Person_id
1819: And P_Effective_Date

Line 2259: Per_All_Assignments_F Asgt

2255: Ben_Per_in_ler PIL,
2256: Ben_Pgm_F Pgm,
2257: Ben_PLip_F Plip,
2258: Ben_Pl_F Pl,
2259: Per_All_Assignments_F Asgt
2260: Where Enrlmt.Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_Id
2261: And Enrlmt.Per_In_Ler_id = Pil.Per_In_Ler_id
2262: And Asgt.Person_id = PIL.Person_id
2263: and Pgm.Pgm_Id = Enrlmt.Pgm_Id

Line 2325: l_Assignment_id Per_All_Assignments_F.Assignment_Id%TYPE;

2321: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2322: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2323: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2324: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;
2325: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2326: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;

2322: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2323: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2324: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;
2325: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2327: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;

2323: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2324: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;
2325: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2328: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;

2324: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;
2325: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2329: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;

2325: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2336: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%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;
2338: l_org_now_no_manager_warning Boolean;
2339: l_other_manager_warning Boolean;
2340: l_spp_delete_warning Boolean;

Line 2337: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_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;
2338: l_org_now_no_manager_warning Boolean;
2339: l_other_manager_warning Boolean;
2340: l_spp_delete_warning Boolean;
2341: l_entries_changed_warning Varchar2(250);

Line 2346: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;

2342: l_tax_district_changed_warning Boolean;
2343: l_concatenated_segments Varchar2(250);
2344: L_DATE_TRACK_MODE Varchar2(25);
2345: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;
2346: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;
2347: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;
2348: Begin
2349:
2350: if g_debug then

Line 2347: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;

2343: l_concatenated_segments Varchar2(250);
2344: L_DATE_TRACK_MODE Varchar2(25);
2345: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;
2346: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;
2347: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;
2348: Begin
2349:
2350: if g_debug then
2351: hr_utility.set_location(' Inside Update_Assgmt_Info ', 10);

Line 2369: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'

2365: If ((l_Asgt_Grade_Id <> l_Grade_id) or (Nvl(l_Asgt_Grdldr_Id,-1) <> l_Pgm_id)) Then
2366: /* Update Assignments with the Grade Ladder / Grade Details */
2367: L_DATE_TRACK_MODE := DT_Mode
2368: (P_EFFECTIVE_DATE => Nvl(l_Enrt_Cvg_Strt_Dt, P_Effective_Date)
2369: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'
2370: ,P_BASE_KEY_COLUMN => 'ASSIGNMENT_ID'
2371: ,P_BASE_KEY_VALUE => L_Assignment_id);
2372:
2373: if g_debug then

Line 2769: From per_all_assignments_f

2765: IS
2766: -- Get assignment details for person from primary assignment.
2767: Cursor csr_asg_details is
2768: Select grade_ladder_pgm_id,grade_id
2769: From per_all_assignments_f
2770: Where person_id = p_person_id
2771: and primary_flag = 'Y'
2772: and assignment_type ='E'
2773: and p_effective_date between effective_start_date and effective_end_date;

Line 2812: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;

2808: and p_effective_date between effective_start_date and effective_end_date
2809: and plip_stat_cd = 'A';
2810:
2811: --
2812: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2813: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2814: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2815: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2816: l_grade_pl ben_pl_f.pl_id%type := NULL;

Line 2813: l_asg_grade per_all_assignments_f.grade_id%type := NULL;

2809: and plip_stat_cd = 'A';
2810:
2811: --
2812: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2813: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2814: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2815: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2816: l_grade_pl ben_pl_f.pl_id%type := NULL;
2817: l_grade_plip ben_plip_f.plip_id%type := NULL;

Line 2936: from Per_All_Assignments_f Asgt

2932: Cursor Person_Info
2933: Is
2934: Select Asgt.Business_Group_id,
2935: Asgt.Grade_Id , Asgt.pay_basis_id, Asgt.GRADE_LADDER_PGM_ID
2936: from Per_All_Assignments_f Asgt
2937: Where P_Effective_Date
2938: Between Asgt.Effective_Start_Date
2939: and Asgt.Effective_End_Date
2940: and Asgt.Person_id = p_person_id

Line 3058: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;

3054:
3055: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3056: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3057: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3058: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3059: l_Grade_Id Per_Grades.Grade_Id%TYPE;
3060: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
3061: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
3062: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;

Line 3403: Per_All_Assignments_F Asgt

3399: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id,Pil.per_in_ler_id, Rate.Ann_val
3400: From Ben_ELig_per_Elctbl_Chc Enrt,
3401: ben_Enrt_Rt Rate,
3402: Ben_Per_in_ler PIL,
3403: Per_All_Assignments_F Asgt
3404: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
3405: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id
3406: And Asgt.Person_id = PIL.Person_id
3407: And P_Effective_Date