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.

[Home] [Help]

APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PRTT_RT_VAL

Line 1525: l_PRTT_RT_VAL_ID1 BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;

1521:
1522: l_PRTT_ENRT_RSLT_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1523: l_Ovn_No BEN_PRTT_ENRT_RSLT_F.Object_Version_Number%TYPE;
1524: L_PRTT_ENRT_INTERIM_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1525: l_PRTT_RT_VAL_ID1 BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1526: l_PRTT_RT_VAL_ID_Cmn BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1527: l_Datetrack_Mode Varchar2(25);
1528: l_suspend_flag Varchar2(1) := 'N';
1529: l_EFFECTIVE_START_DATE Date;

Line 1526: l_PRTT_RT_VAL_ID_Cmn BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;

1522: l_PRTT_ENRT_RSLT_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1523: l_Ovn_No BEN_PRTT_ENRT_RSLT_F.Object_Version_Number%TYPE;
1524: L_PRTT_ENRT_INTERIM_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1525: l_PRTT_RT_VAL_ID1 BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1526: l_PRTT_RT_VAL_ID_Cmn BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1527: l_Datetrack_Mode Varchar2(25);
1528: l_suspend_flag Varchar2(1) := 'N';
1529: l_EFFECTIVE_START_DATE Date;
1530: L_EFFECTIVE_END_DATE Date;

Line 1927: ben_prtt_rt_val Rate,

1923: Select Rate.rt_Val , Rate.Rt_Strt_Dt, Rate.Prtt_Rt_Val_Id,
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

Line 1943: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;

1939:
1940: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1941: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1942:
1943: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1944: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
1945: L_INV_NEXT_SAL_DATE_WARNING Boolean;
1946: L_PROPOSED_SALARY_WARNING Boolean;
1947: L_APPROVED_WARNING Boolean;

Line 1944: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

1940: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1941: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1942:
1943: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1944: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
1945: L_INV_NEXT_SAL_DATE_WARNING Boolean;
1946: L_PROPOSED_SALARY_WARNING Boolean;
1947: L_APPROVED_WARNING Boolean;
1948: L_PAYROLL_WARNING Boolean;

Line 2288: Ben_Prtt_Rt_Val_Api.UPDATE_PRTT_RT_VAL

2284:
2285: -- l_Rt_Ovn := L_Enroll_Info.Object_Version_Number;
2286:
2287: /*
2288: Ben_Prtt_Rt_Val_Api.UPDATE_PRTT_RT_VAL
2289: (P_PRTT_RT_VAL_ID => L_Enroll_Info.PRTT_RT_VAL_ID
2290: ,P_PK_ID_TABLE_NAME => 'PER_PAY_PROPOSALS'
2291: ,P_PK_ID => l_Pay_Proposal_Id
2292: ,P_OBJECT_VERSION_NUMBER => L_Rt_Ovn

Line 3521: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;

3517: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3518: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3519: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3520: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3521: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3522: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3523: L_INV_NEXT_SAL_DATE_WARNING Boolean;
3524: L_PROPOSED_SALARY_WARNING Boolean;
3525: L_APPROVED_WARNING Boolean;

Line 3522: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

3518: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3519: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3520: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3521: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3522: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3523: L_INV_NEXT_SAL_DATE_WARNING Boolean;
3524: L_PROPOSED_SALARY_WARNING Boolean;
3525: L_APPROVED_WARNING Boolean;
3526: l_salary_change_date date;