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 BEN_PER_IN_LER

Line 117: l_Last_Per_In_ler_Id Ben_Per_In_ler.Per_in_ler_Id%TYPE;

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;
118: l_Lst_Rt_Chg_Dt Ben_Enrt_Rt.Rt_Strt_Dt%TYPE;
119: l_Le_Exists Varchar2(1);
120:
121: Cursor Person_Dtls is

Line 186: From Ben_Per_in_ler PIL,

182: ---
183:
184: Cursor csr_le is
185: Select max(pil.Per_in_Ler_Id)
186: From Ben_Per_in_ler PIL,
187: Ben_Ler_F LER
188: Where Pil.Ler_Id = LER.Ler_Id
189: And Pil.LF_EVT_OCRD_DT = P_Effective_Date
190: And ler.typ_Cd = 'GSP'

Line 206: from Ben_Per_in_ler Pler,

202: And Rate.ELIG_PER_ELCTBL_CHC_ID(+) = Elct.ELIG_PER_ELCTBL_CHC_ID;
203:
204: Cursor Strtd_Le_Exits is
205: Select 'X'
206: from Ben_Per_in_ler Pler,
207: Ben_Ler_F Ler
208: where Person_id = l_Person_Id
209: and Per_In_ler_Stat_Cd = 'STRTD'
210: and Pler.Ler_Id = Ler.ler_ID

Line 388: Ben_Per_In_Ler Pler

384:
385: Cursor Pler is
386: Select Pler.Per_In_Ler_Id, Pler.Object_Version_Number, Elct.Pgm_Id
387: From Ben_Elig_per_Elctbl_Chc Elct,
388: Ben_Per_In_Ler Pler
389: Where Elct.Elig_per_Elctbl_Chc_Id = P_Elig_per_Elctbl_Chc_Id
390: and Pler.Per_In_Ler_Id = Elct.Per_In_Ler_Id;
391:
392: Cursor Pgm_Dtl(P_Pgm_Id In Number) Is

Line 400: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;

396: and P_Effective_Date
397: Between Effective_Start_Date
398: and Effective_End_Date;
399:
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;

Line 401: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;

397: Between Effective_Start_Date
398: and Effective_End_Date;
399:
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:

Line 582: from Ben_Per_in_ler Pler,

578: End If;
579:
580:
581: Select Count(*) into L_Cnt
582: from Ben_Per_in_ler Pler,
583: Ben_Ler_F Ler
584: where Person_id = Asgt_Rec.Person_Id
585: and Per_In_ler_Stat_Cd = 'STRTD'
586: and Pler.Ler_Id = Ler.ler_ID

Line 851: from Ben_per_in_Ler

847: Where Pgm_Id = P_Pgm_Id
848: and Dflt_Flag = 'Y'
849: and Elctbl_Flag = 'Y'
850: and Per_In_ler_Id = (Select Max(Per_In_ler_Id)
851: from Ben_per_in_Ler
852: Where Ler_id = P_Ler_Id
853: and Person_Id = P_Person_Id
854: and LF_EVT_OCRD_DT = ( SELECT max(LF_EVT_OCRD_DT) FROM Ben_per_in_Ler
855: where Ler_id = P_Ler_Id

Line 854: and LF_EVT_OCRD_DT = ( SELECT max(LF_EVT_OCRD_DT) FROM Ben_per_in_Ler

850: and Per_In_ler_Id = (Select Max(Per_In_ler_Id)
851: from Ben_per_in_Ler
852: Where Ler_id = P_Ler_Id
853: and Person_Id = P_Person_Id
854: and LF_EVT_OCRD_DT = ( SELECT max(LF_EVT_OCRD_DT) FROM Ben_per_in_Ler
855: where Ler_id = P_Ler_Id
856: and Person_Id = P_Person_Id
857: and PER_IN_LER_STAT_CD = 'PROCD'
858: and LF_EVT_OCRD_DT <= p_effective_date)

Line 865: from Ben_per_in_Ler

861: --bug 4125962
862: Cursor csr_max_lf_evt_date (P_Person_Id in Number,p_ler_id in number)
863: Is
864: select max(LF_EVT_OCRD_DT)
865: from Ben_per_in_Ler
866: Where Person_Id = P_Person_Id
867: and Ler_id = P_Ler_Id;
868:
869: Cursor Csr_prev_assignment(P_Person_Id in Number,p_max_lf_evt_date in date)

Line 914: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;

910: L_person_Id Per_All_People_F.Person_Id%TYPE;
911: l_Ler_id Ben_ler_F.Ler_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;

Line 915: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;

911: l_Ler_id Ben_ler_F.Ler_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;

Line 1441: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

1437: ,P_Elig_per_Elctbl_Chc_Id IN Number
1438: ,p_current_rate_change_dt IN Date) is
1439:
1440: --
1441: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1442: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1443: l_person_id ben_per_in_ler.person_id%type;
1444: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1445: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;

Line 1442: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

1438: ,p_current_rate_change_dt IN Date) is
1439:
1440: --
1441: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1442: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1443: l_person_id ben_per_in_ler.person_id%type;
1444: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1445: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1446: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;

Line 1443: l_person_id ben_per_in_ler.person_id%type;

1439:
1440: --
1441: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1442: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1443: l_person_id ben_per_in_ler.person_id%type;
1444: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1445: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1446: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1447: l_prev_sal ben_enrt_rt.val%type;

Line 1497: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt

1493: -- Get current Per_in_ler
1494: --
1495: Cursor csr_curr_le is
1496: Select pil.Per_in_Ler_Id, pil.person_id
1497: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt
1498: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1499: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id;
1500: --And Pil.LF_EVT_OCRD_DT = P_Effective_Date;
1501: -- And Pil.Per_In_Ler_Stat_Cd = 'PROCD';

Line 1507: From Ben_Per_in_ler PIL,

1503: -- Get prev per_in_ler
1504: --
1505: Cursor csr_prev_le is
1506: Select max(pil.Per_in_Ler_Id)
1507: From Ben_Per_in_ler PIL,
1508: Ben_Ler_F LER
1509: Where Pil.Ler_Id = LER.Ler_Id
1510: And ler.typ_Cd = 'GSP'
1511: And Pil.person_Id = l_person_id

Line 1534: From Ben_Per_in_ler PIL,

1530: Ben_Enrt_Rt Rate
1531: Where Elct.DFLT_FLAG = 'Y'
1532: and Elct.Elctbl_Flag = 'Y'
1533: and Elct.Per_in_ler_id in (Select pil.Per_in_Ler_Id
1534: From Ben_Per_in_ler PIL,
1535: Ben_Ler_F LER
1536: Where Pil.Ler_Id = LER.Ler_Id
1537: And ler.typ_Cd = 'GSP'
1538: And Pil.person_Id = l_person_id

Line 1814: Ben_Per_in_ler PIL,

1810: Rate.Object_Version_Number, Enrt.Pgm_Id, Enrt.OiPl_Id,
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

Line 2255: Ben_Per_in_ler PIL,

2251: Enrlmt.Enrt_Cvg_Strt_Dt, Pgm.Dflt_Step_CD, Pl.MAPPING_TABLE_PK_ID, Asgt.Assignment_Id,
2252: Asgt.Object_Version_Number , Asgt.SPECIAL_CEILING_STEP_ID, Asgt.People_Group_Id,
2253: Asgt.Soft_Coding_Keyflex_Id, Asgt.Grade_Id, Asgt.Grade_Ladder_Pgm_Id
2254: From Ben_Elig_Per_Elctbl_Chc Enrlmt,
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

Line 2504: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;

2500: l_Error_Message Varchar2(250);
2501: L_Concurrent_Req_Id Number(18);
2502: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;
2503:
2504: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
2505: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
2506: l_PROCD_DT DATE;
2507: l_STRTD_DT DATE;
2508: l_VOIDD_DT Date;

Line 2505: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;

2501: L_Concurrent_Req_Id Number(18);
2502: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;
2503:
2504: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
2505: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
2506: l_PROCD_DT DATE;
2507: l_STRTD_DT DATE;
2508: l_VOIDD_DT Date;
2509: L_Effective_Date Date;

Line 2510: l_Per_In_ler_Stat_Cd Ben_Per_In_Ler.Per_In_Ler_Stat_Cd%TYPE;

2506: l_PROCD_DT DATE;
2507: l_STRTD_DT DATE;
2508: l_VOIDD_DT Date;
2509: L_Effective_Date Date;
2510: l_Per_In_ler_Stat_Cd Ben_Per_In_Ler.Per_In_Ler_Stat_Cd%TYPE;
2511: l_Error_Exists Varchar2(1) := 'N';
2512: l_conc_status boolean;
2513:
2514: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

Line 2520: from ben_per_in_ler per

2516:
2517: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2518: is
2519: select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number
2520: from ben_per_in_ler per
2521: ,ben_ptnl_ler_for_per ptnl
2522: where per.per_in_ler_id = p_per_in_ler_id
2523: and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
2524:

Line 2530: Ben_Per_in_ler Pil,

2526: Select Elct.ELIG_PER_ELCTBL_CHC_ID, Pil.Person_Id, Pil.Per_In_Ler_id, Pil. Object_Version_Number,
2527: Elct.Enrt_Cvg_Strt_Dt, Pgm.Update_Salary_Cd, Pgm.Dflt_Step_Cd, Elct.Approval_Status_Cd, Person.Full_name
2528: From ben_Elig_Per_Elctbl_Chc Elct,
2529: Ben_Ler_F Ler,
2530: Ben_Per_in_ler Pil,
2531: Ben_Pgm_F PGM,
2532: Per_All_People_F Person
2533: where Ler.typ_Cd = 'GSP'
2534: and L_Effective_Date

Line 2929: from ben_per_in_ler

2925:
2926: Cursor per_in_ler_dtls
2927: IS
2928: select ler_id,program_id,business_group_id
2929: from ben_per_in_ler
2930: where per_in_ler_id = p_per_in_ler_id;
2931:
2932: Cursor Person_Info
2933: Is

Line 3057: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;

3053: and Business_Group_id = Hr_general.get_business_group_id;
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;

Line 3345: from ben_per_in_ler

3341:
3342: Cursor csr_pil_dtls
3343: IS
3344: select object_version_number,PTNL_LER_FOR_PER_ID
3345: from ben_per_in_ler
3346: where per_in_ler_id = p_per_in_ler_id;
3347:
3348: Cursor csr_ptnl_ler_dtls(p_PTNL_LER_FOR_PER_ID in number)
3349: IS

Line 3402: Ben_Per_in_ler PIL,

3398: Rate.Object_Version_Number, Enrt.Pgm_Id, Enrt.OiPl_Id,
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