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 429: Ben_Per_In_Ler Pler

425:
426: Cursor Pler is
427: Select Pler.Per_In_Ler_Id, Pler.Object_Version_Number, Elct.Pgm_Id
428: From Ben_Elig_per_Elctbl_Chc Elct,
429: Ben_Per_In_Ler Pler
430: Where Elct.Elig_per_Elctbl_Chc_Id = P_Elig_per_Elctbl_Chc_Id
431: and Pler.Per_In_Ler_Id = Elct.Per_In_Ler_Id;
432:
433: Cursor Pgm_Dtl(P_Pgm_Id In Number) Is

Line 441: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;

437: and P_Effective_Date
438: Between Effective_Start_Date
439: and Effective_End_Date;
440:
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;

Line 442: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;

438: Between Effective_Start_Date
439: and Effective_End_Date;
440:
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:

Line 623: from Ben_Per_in_ler Pler,

619: End If;
620:
621:
622: Select Count(*) into L_Cnt
623: from Ben_Per_in_ler Pler,
624: Ben_Ler_F Ler
625: where Person_id = Asgt_Rec.Person_Id
626: and Per_In_ler_Stat_Cd = 'STRTD'
627: and Pler.Ler_Id = Ler.ler_ID

Line 892: from Ben_per_in_Ler

888: Where Pgm_Id = P_Pgm_Id
889: and Dflt_Flag = 'Y'
890: and Elctbl_Flag = 'Y'
891: and Per_In_ler_Id = (Select Max(Per_In_ler_Id)
892: from Ben_per_in_Ler
893: Where Ler_id = P_Ler_Id
894: and Person_Id = P_Person_Id
895: and LF_EVT_OCRD_DT = ( SELECT max(LF_EVT_OCRD_DT) FROM Ben_per_in_Ler
896: where Ler_id = P_Ler_Id

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

891: and Per_In_ler_Id = (Select Max(Per_In_ler_Id)
892: from Ben_per_in_Ler
893: Where Ler_id = P_Ler_Id
894: and Person_Id = P_Person_Id
895: and LF_EVT_OCRD_DT = ( SELECT max(LF_EVT_OCRD_DT) FROM Ben_per_in_Ler
896: where Ler_id = P_Ler_Id
897: and Person_Id = P_Person_Id
898: and PER_IN_LER_STAT_CD = 'PROCD'
899: and LF_EVT_OCRD_DT <= p_effective_date)

Line 906: from Ben_per_in_Ler

902: --bug 4125962
903: Cursor csr_max_lf_evt_date (P_Person_Id in Number,p_ler_id in number)
904: Is
905: select max(LF_EVT_OCRD_DT)
906: from Ben_per_in_Ler
907: Where Person_Id = P_Person_Id
908: and Ler_id = P_Ler_Id;
909:
910: Cursor Csr_prev_assignment(P_Person_Id in Number,p_max_lf_evt_date in date)

Line 1015: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;

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

Line 1016: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;

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

Line 1601: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

1597: ,P_Elig_per_Elctbl_Chc_Id IN Number
1598: ,p_current_rate_change_dt IN Date) is
1599:
1600: --
1601: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1602: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1603: l_person_id ben_per_in_ler.person_id%type;
1604: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1605: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;

Line 1602: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

1598: ,p_current_rate_change_dt IN Date) is
1599:
1600: --
1601: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1602: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1603: l_person_id ben_per_in_ler.person_id%type;
1604: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1605: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1606: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;

Line 1603: l_person_id ben_per_in_ler.person_id%type;

1599:
1600: --
1601: l_curr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1602: l_last_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1603: l_person_id ben_per_in_ler.person_id%type;
1604: l_prev_sal_change_dt ben_enrt_rt.rt_strt_dt%type;
1605: l_max_rt_change_dt ben_enrt_rt.rt_strt_dt%type;
1606: l_prev_grade_ladder_id ben_elig_per_elctbl_chc.pgm_id%type;
1607: l_prev_sal ben_enrt_rt.val%type;

Line 1657: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt

1653: -- Get current Per_in_ler
1654: --
1655: Cursor csr_curr_le is
1656: Select pil.Per_in_Ler_Id, pil.person_id
1657: From Ben_Per_in_ler PIL, Ben_Elig_Per_Elctbl_Chc Enrt
1658: Where Enrt.Elig_per_Elctbl_Chc_id = P_Elig_per_Elctbl_Chc_Id
1659: And Enrt.Per_In_Ler_id = Pil.Per_In_Ler_id;
1660: --And Pil.LF_EVT_OCRD_DT = P_Effective_Date;
1661: -- And Pil.Per_In_Ler_Stat_Cd = 'PROCD';

Line 1667: From Ben_Per_in_ler PIL,

1663: -- Get prev per_in_ler
1664: --
1665: Cursor csr_prev_le is
1666: Select max(pil.Per_in_Ler_Id)
1667: From Ben_Per_in_ler PIL,
1668: Ben_Ler_F LER
1669: Where Pil.Ler_Id = LER.Ler_Id
1670: And ler.typ_Cd = 'GSP'
1671: And Pil.person_Id = l_person_id

Line 1694: From Ben_Per_in_ler PIL,

1690: Ben_Enrt_Rt Rate
1691: Where Elct.DFLT_FLAG = 'Y'
1692: and Elct.Elctbl_Flag = 'Y'
1693: and Elct.Per_in_ler_id in (Select pil.Per_in_Ler_Id
1694: From Ben_Per_in_ler PIL,
1695: Ben_Ler_F LER
1696: Where Pil.Ler_Id = LER.Ler_Id
1697: And ler.typ_Cd = 'GSP'
1698: And Pil.person_Id = l_person_id

Line 1974: Ben_Per_in_ler PIL,

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

Line 2415: Ben_Per_in_ler PIL,

2411: Enrlmt.Enrt_Cvg_Strt_Dt, Pgm.Dflt_Step_CD, Pl.MAPPING_TABLE_PK_ID, Asgt.Assignment_Id,
2412: Asgt.Object_Version_Number , Asgt.SPECIAL_CEILING_STEP_ID, Asgt.People_Group_Id,
2413: Asgt.Soft_Coding_Keyflex_Id, Asgt.Grade_Id, Asgt.Grade_Ladder_Pgm_Id
2414: From Ben_Elig_Per_Elctbl_Chc Enrlmt,
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

Line 2664: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;

2660: l_Error_Message Varchar2(250);
2661: L_Concurrent_Req_Id Number(18);
2662: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;
2663:
2664: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
2665: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
2666: l_PROCD_DT DATE;
2667: l_STRTD_DT DATE;
2668: l_VOIDD_DT Date;

Line 2665: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;

2661: L_Concurrent_Req_Id Number(18);
2662: l_Progression_Style Ben_Pgm_F.Dflt_Step_Cd%TYPE;
2663:
2664: L_Per_In_Ler_id Ben_Per_In_ler.Per_In_Ler_Id%TYPE;
2665: L_Pil_Ovn Ben_Per_In_ler.Object_Version_Number%TYPE;
2666: l_PROCD_DT DATE;
2667: l_STRTD_DT DATE;
2668: l_VOIDD_DT Date;
2669: L_Effective_Date Date;

Line 2670: l_Per_In_ler_Stat_Cd Ben_Per_In_Ler.Per_In_Ler_Stat_Cd%TYPE;

2666: l_PROCD_DT DATE;
2667: l_STRTD_DT DATE;
2668: l_VOIDD_DT Date;
2669: L_Effective_Date Date;
2670: l_Per_In_ler_Stat_Cd Ben_Per_In_Ler.Per_In_Ler_Stat_Cd%TYPE;
2671: l_Error_Exists Varchar2(1) := 'N';
2672: l_conc_status boolean;
2673:
2674: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

Line 2680: from ben_per_in_ler per

2676:
2677: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2678: is
2679: select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number
2680: from ben_per_in_ler per
2681: ,ben_ptnl_ler_for_per ptnl
2682: where per.per_in_ler_id = p_per_in_ler_id
2683: and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
2684:

Line 2690: Ben_Per_in_ler Pil,

2686: Select Elct.ELIG_PER_ELCTBL_CHC_ID, Pil.Person_Id, Pil.Per_In_Ler_id, Pil. Object_Version_Number,
2687: Elct.Enrt_Cvg_Strt_Dt, Pgm.Update_Salary_Cd, Pgm.Dflt_Step_Cd, Elct.Approval_Status_Cd, Person.Full_name
2688: From ben_Elig_Per_Elctbl_Chc Elct,
2689: Ben_Ler_F Ler,
2690: Ben_Per_in_ler Pil,
2691: Ben_Pgm_F PGM,
2692: Per_All_People_F Person
2693: where Ler.typ_Cd = 'GSP'
2694: and L_Effective_Date

Line 3089: from ben_per_in_ler

3085:
3086: Cursor per_in_ler_dtls
3087: IS
3088: select ler_id,program_id,business_group_id
3089: from ben_per_in_ler
3090: where per_in_ler_id = p_per_in_ler_id;
3091:
3092: Cursor Person_Info
3093: Is

Line 3217: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;

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

Line 3505: from ben_per_in_ler

3501:
3502: Cursor csr_pil_dtls
3503: IS
3504: select object_version_number,PTNL_LER_FOR_PER_ID
3505: from ben_per_in_ler
3506: where per_in_ler_id = p_per_in_ler_id;
3507:
3508: Cursor csr_ptnl_ler_dtls(p_PTNL_LER_FOR_PER_ID in number)
3509: IS

Line 3562: Ben_Per_in_ler PIL,

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