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 224: select GRADE_LADDER_PGM_ID,GRADE_ID from per_all_assignments_f asg

220: l_new_grd number;
221:
222: -- Bug 16285614
223: cursor old_grdldr is
224: select GRADE_LADDER_PGM_ID,GRADE_ID from per_all_assignments_f asg
225: where asg.assignment_id = P_Assignment_Id
226: and asg.effective_end_date = P_Effective_Date - 1
227: and asg.primary_flag = 'Y'
228: and asg.assignment_type ='E';

Line 233: select GRADE_LADDER_PGM_ID, GRADE_ID from per_all_assignments_f asg

229:
230:
231:
232: cursor new_grdldr is
233: select GRADE_LADDER_PGM_ID, GRADE_ID from per_all_assignments_f asg
234: where asg.assignment_id = P_Assignment_Id
235: and P_Effective_Date between asg.effective_start_date and asg.effective_end_date
236: and asg.primary_flag = 'Y'
237: and asg.assignment_type ='E';

Line 445: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;

441: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
442: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
443: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
444: l_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
445: l_Assignment_id Per_All_Assignments_F.Assignment_id%TYPE;
446:
447: l_PROCD_DT DATE;
448: l_STRTD_DT DATE;
449: l_VOIDD_DT Date;

Line 549: from Per_All_Assignments_F Paa

545: Cursor Asgt_Dtls
546: Is
547: Select Paa.Assignment_Id, Paa.Grade_ladder_Pgm_Id, Paa.Grade_Id, Paa.Person_Id,
548: paa.soft_coding_keyflex_id,paa.people_group_id,paa.special_ceiling_step_id,paa.object_version_number
549: from Per_All_Assignments_F Paa
550: Where L_Effective_Date Between paa.Effective_Start_Date and Paa.Effective_End_Date
551: and Paa.Business_group_id = hr_General.get_Business_group_id
552: and Paa.Person_id = Nvl(P_Person_Id, Paa.Person_Id)
553: and paa.assignment_type ='E'

Line 572: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;

568: L_Cnt Number := 0;
569: L_Error_Exists Varchar2(1) := 'N';
570: l_conc_status boolean;
571:
572: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
573: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
574: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
575: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;

Line 573: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;

569: L_Error_Exists Varchar2(1) := 'N';
570: l_conc_status boolean;
571:
572: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
573: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
574: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
575: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
577: L_DATE_TRACK_MODE Varchar2(25);

Line 574: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;

570: l_conc_status boolean;
571:
572: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
573: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
574: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
575: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
577: L_DATE_TRACK_MODE Varchar2(25);
578: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;

Line 575: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;

571:
572: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;
573: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;
574: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
575: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
577: L_DATE_TRACK_MODE Varchar2(25);
578: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
579: l_group_name Varchar2(250);

Line 578: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;

574: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;
575: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;
576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
577: L_DATE_TRACK_MODE Varchar2(25);
578: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
579: l_group_name Varchar2(250);
580: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
581: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;
582: l_org_now_no_manager_warning Boolean;

Line 580: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;

576: L_Pgm_Id ben_pgm_f.pgm_id%TYPE;
577: L_DATE_TRACK_MODE Varchar2(25);
578: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
579: l_group_name Varchar2(250);
580: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
581: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;
582: l_org_now_no_manager_warning Boolean;
583: l_other_manager_warning Boolean;
584: l_spp_delete_warning Boolean;

Line 581: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;

577: L_DATE_TRACK_MODE Varchar2(25);
578: l_assignment_id Per_All_Assignments_F.assignment_id%TYPE;
579: l_group_name Varchar2(250);
580: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
581: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;
582: l_org_now_no_manager_warning Boolean;
583: l_other_manager_warning Boolean;
584: l_spp_delete_warning Boolean;
585: l_entries_changed_warning Varchar2(250);

Line 666: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'

662: if l_person_rule_checked then
663:
664: L_DATE_TRACK_MODE := pqh_gsp_post_process.DT_Mode
665: (P_EFFECTIVE_DATE => L_Effective_Date
666: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'
667: ,P_BASE_KEY_COLUMN => 'ASSIGNMENT_ID'
668: ,P_BASE_KEY_VALUE => L_Assignment_id);
669: hr_utility.set_location('L_date_track_mode:'||L_DATE_TRACK_MODE,90);
670: IF l_date_track_mode = 'CORRECTION' OR l_date_track_mode = 'UPDATE' THEN

Line 772: from Per_All_Assignments_f Asgt

768:
769: Cursor Person_Info Is
770: Select Asgt.Person_Id, Asgt.Business_Group_id,
771: Asgt.Grade_Id , Asgt.pay_basis_id, Asgt.GRADE_LADDER_PGM_ID, Asgt.Effective_Start_Date
772: from Per_All_Assignments_f Asgt
773: Where Assignment_Id = P_Assignment_Id
774: and P_Effective_Date
775: Between Asgt.Effective_Start_Date
776: and Asgt.Effective_End_Date;

Line 913: from per_all_assignments_f

909:
910: Cursor Csr_prev_assignment(P_Person_Id in Number,p_max_lf_evt_date in date)
911: IS
912: select assignment_id
913: from per_all_assignments_f
914: where person_id = p_person_id
915: and assignment_type ='E'
916: and primary_flag ='Y'
917: and p_max_lf_evt_date

Line 966: p_assignment_id per_all_assignments_f.assignment_id%type) is

962: -- Bug 13532919
963: -- Bug 16285614
964: cursor csr_step_val
965: (p_effective_date date,
966: p_assignment_id per_all_assignments_f.assignment_id%type) is
967: SELECT grd.value
968: FROM pay_grade_rules_f grd
969: WHERE p_effective_date between grd.effective_start_date AND grd.effective_end_date
970:

Line 1000: from per_all_assignments_f

996: select pay_annualization_factor
997: from per_pay_bases
998: where pay_basis_id in (
999: select pay_basis_id
1000: from per_all_assignments_f
1001: where assignment_id= P_Assignment_id
1002: and P_Effective_Date between effective_start_date and effective_end_date);
1003:
1004:

Line 1017: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;

1013: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
1014: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
1015: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
1016: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
1017: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
1018: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;
1019: l_Grade_Id Per_Grades.Grade_Id%TYPE;
1020: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
1021: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;

Line 1018: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;

1014: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
1015: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
1016: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
1017: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
1018: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;
1019: l_Grade_Id Per_Grades.Grade_Id%TYPE;
1020: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
1021: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
1022: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;

Line 1928: Per_All_Assignments_F Asgt

1924: Rate.pk_Id , Rate.Object_Version_Number, Enrt.Pgm_Id,
1925: Asgt.Assignment_Id, Asgt.pay_basis_id, Enrt.Business_Group_id
1926: From Ben_PRTT_ENRT_RSLT_F Enrt,
1927: ben_prtt_rt_val Rate,
1928: Per_All_Assignments_F Asgt
1929: Where Enrt.PRTT_ENRT_RSLT_ID = P_PRTT_ENRT_RSLT_ID
1930: and P_Effective_Date
1931: between Enrt.Effective_Start_Date
1932: and Enrt.Effective_End_Date

Line 1975: Per_All_Assignments_F Asgt

1971: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id
1972: From Ben_ELig_per_Elctbl_Chc Enrt,
1973: ben_Enrt_Rt Rate,
1974: Ben_Per_in_ler PIL,
1975: Per_All_Assignments_F Asgt
1976: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1977: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id
1978: And Asgt.Person_id = PIL.Person_id
1979: And P_Effective_Date

Line 2419: Per_All_Assignments_F Asgt

2415: Ben_Per_in_ler PIL,
2416: Ben_Pgm_F Pgm,
2417: Ben_PLip_F Plip,
2418: Ben_Pl_F Pl,
2419: Per_All_Assignments_F Asgt
2420: Where Enrlmt.Elig_Per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_Id
2421: And Enrlmt.Per_In_Ler_id = Pil.Per_In_Ler_id
2422: And Asgt.Person_id = PIL.Person_id
2423: and Pgm.Pgm_Id = Enrlmt.Pgm_Id

Line 2485: l_Assignment_id Per_All_Assignments_F.Assignment_Id%TYPE;

2481: l_Grade_Id Per_Grades.Grade_Id%TYPE;
2482: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2483: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2484: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;
2485: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2486: l_Assignment_Ovn Per_All_Assignments_F.Object_Version_Number%TYPE;

2482: l_Step_Id Per_Spinal_point_Steps_F.Step_Id%TYPE;
2483: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2484: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;
2485: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2487: l_SPECIAL_CEILING_STEP_ID Per_All_Assignments_F.SPECIAL_CEILING_STEP_ID%TYPE;

2483: l_Spinal_point_id Per_Spinal_point_Steps_F.Spinal_Point_Id%TYPE;
2484: l_Grade_spine_id Per_Spinal_point_Steps_F.Grade_Spine_Id%TYPE;
2485: l_Assignment_id Per_All_Assignments_F.Assignment_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;

Line 2488: L_People_Group_Id Per_All_Assignments_F.People_Group_Id%TYPE;

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

Line 2489: l_Soft_Coding_Keyflex_Id Per_All_Assignments_F.Soft_Coding_Keyflex_Id%TYPE;

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

Line 2496: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%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;
2498: l_org_now_no_manager_warning Boolean;
2499: l_other_manager_warning Boolean;
2500: l_spp_delete_warning Boolean;

Line 2497: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_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;
2498: l_org_now_no_manager_warning Boolean;
2499: l_other_manager_warning Boolean;
2500: l_spp_delete_warning Boolean;
2501: l_entries_changed_warning Varchar2(250);

Line 2506: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;

2502: l_tax_district_changed_warning Boolean;
2503: l_concatenated_segments Varchar2(250);
2504: L_DATE_TRACK_MODE Varchar2(25);
2505: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;
2506: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;
2507: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;
2508: Begin
2509:
2510: if g_debug then

Line 2507: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;

2503: l_concatenated_segments Varchar2(250);
2504: L_DATE_TRACK_MODE Varchar2(25);
2505: l_Enrt_Cvg_Strt_Dt Ben_Elig_Per_Elctbl_Chc.Enrt_Cvg_Strt_Dt%TYPE;
2506: l_Asgt_grade_Id Per_All_Assignments_F.Grade_Id%TYPE;
2507: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;
2508: Begin
2509:
2510: if g_debug then
2511: hr_utility.set_location(' Inside Update_Assgmt_Info ', 10);

Line 2529: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'

2525: If ((l_Asgt_Grade_Id <> l_Grade_id) or (Nvl(l_Asgt_Grdldr_Id,-1) <> l_Pgm_id)) Then
2526: /* Update Assignments with the Grade Ladder / Grade Details */
2527: L_DATE_TRACK_MODE := DT_Mode
2528: (P_EFFECTIVE_DATE => Nvl(l_Enrt_Cvg_Strt_Dt, P_Effective_Date)
2529: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'
2530: ,P_BASE_KEY_COLUMN => 'ASSIGNMENT_ID'
2531: ,P_BASE_KEY_VALUE => L_Assignment_id);
2532:
2533: if g_debug then

Line 2929: From per_all_assignments_f

2925: IS
2926: -- Get assignment details for person from primary assignment.
2927: Cursor csr_asg_details is
2928: Select grade_ladder_pgm_id,grade_id
2929: From per_all_assignments_f
2930: Where person_id = p_person_id
2931: and primary_flag = 'Y'
2932: and assignment_type ='E'
2933: and p_effective_date between effective_start_date and effective_end_date;

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

2968: and p_effective_date between effective_start_date and effective_end_date
2969: and plip_stat_cd = 'A';
2970:
2971: --
2972: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2973: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2974: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2975: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2976: l_grade_pl ben_pl_f.pl_id%type := NULL;

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

2969: and plip_stat_cd = 'A';
2970:
2971: --
2972: l_asg_gl per_all_assignments_f.grade_ladder_pgm_id%type := NULL;
2973: l_asg_grade per_all_assignments_f.grade_id%type := NULL;
2974: l_def_gl ben_pgm_f.pgm_id%type := NULL;
2975: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type := NULL;
2976: l_grade_pl ben_pl_f.pl_id%type := NULL;
2977: l_grade_plip ben_plip_f.plip_id%type := NULL;

Line 3096: from Per_All_Assignments_f Asgt

3092: Cursor Person_Info
3093: Is
3094: Select Asgt.Business_Group_id,
3095: Asgt.Grade_Id , Asgt.pay_basis_id, Asgt.GRADE_LADDER_PGM_ID
3096: from Per_All_Assignments_f Asgt
3097: Where P_Effective_Date
3098: Between Asgt.Effective_Start_Date
3099: and Asgt.Effective_End_Date
3100: and Asgt.Person_id = p_person_id

Line 3218: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;

3214:
3215: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3216: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3217: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3218: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3219: l_Grade_Id Per_Grades.Grade_Id%TYPE;
3220: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;
3221: l_Step_Id Per_Spinal_Point_Steps_f.Step_Id%TYPE;
3222: l_Point_id Per_Spinal_POints.Spinal_Point_Id%TYPE;

Line 3563: Per_All_Assignments_F Asgt

3559: Asgt.Assignment_Id, Asgt.pay_basis_id, Asgt.Grade_Id, Enrt.Business_Group_id,Pil.per_in_ler_id, Rate.Ann_val
3560: From Ben_ELig_per_Elctbl_Chc Enrt,
3561: ben_Enrt_Rt Rate,
3562: Ben_Per_in_ler PIL,
3563: Per_All_Assignments_F Asgt
3564: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
3565: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id
3566: And Asgt.Person_id = PIL.Person_id
3567: And P_Effective_Date