APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PRTT_RT_VAL

Line 1365: l_PRTT_RT_VAL_ID1 BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;

1361:
1362: l_PRTT_ENRT_RSLT_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1363: l_Ovn_No BEN_PRTT_ENRT_RSLT_F.Object_Version_Number%TYPE;
1364: L_PRTT_ENRT_INTERIM_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1365: l_PRTT_RT_VAL_ID1 BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1366: l_PRTT_RT_VAL_ID_Cmn BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1367: l_Datetrack_Mode Varchar2(25);
1368: l_suspend_flag Varchar2(1) := 'N';
1369: l_EFFECTIVE_START_DATE Date;

Line 1366: l_PRTT_RT_VAL_ID_Cmn BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;

1362: l_PRTT_ENRT_RSLT_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1363: l_Ovn_No BEN_PRTT_ENRT_RSLT_F.Object_Version_Number%TYPE;
1364: L_PRTT_ENRT_INTERIM_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
1365: l_PRTT_RT_VAL_ID1 BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1366: l_PRTT_RT_VAL_ID_Cmn BEN_PRTT_RT_VAL.PRTT_RT_VAL_ID%TYPE;
1367: l_Datetrack_Mode Varchar2(25);
1368: l_suspend_flag Varchar2(1) := 'N';
1369: l_EFFECTIVE_START_DATE Date;
1370: L_EFFECTIVE_END_DATE Date;

Line 1767: ben_prtt_rt_val Rate,

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

Line 1783: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;

1779:
1780: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1781: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1782:
1783: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1784: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
1785: L_INV_NEXT_SAL_DATE_WARNING Boolean;
1786: L_PROPOSED_SALARY_WARNING Boolean;
1787: L_APPROVED_WARNING Boolean;

Line 1784: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

1780: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1781: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1782:
1783: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1784: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
1785: L_INV_NEXT_SAL_DATE_WARNING Boolean;
1786: L_PROPOSED_SALARY_WARNING Boolean;
1787: L_APPROVED_WARNING Boolean;
1788: L_PAYROLL_WARNING Boolean;

Line 2128: Ben_Prtt_Rt_Val_Api.UPDATE_PRTT_RT_VAL

2124:
2125: -- l_Rt_Ovn := L_Enroll_Info.Object_Version_Number;
2126:
2127: /*
2128: Ben_Prtt_Rt_Val_Api.UPDATE_PRTT_RT_VAL
2129: (P_PRTT_RT_VAL_ID => L_Enroll_Info.PRTT_RT_VAL_ID
2130: ,P_PK_ID_TABLE_NAME => 'PER_PAY_PROPOSALS'
2131: ,P_PK_ID => l_Pay_Proposal_Id
2132: ,P_OBJECT_VERSION_NUMBER => L_Rt_Ovn

Line 3361: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;

3357: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3358: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3359: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3360: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3361: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3362: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3363: L_INV_NEXT_SAL_DATE_WARNING Boolean;
3364: L_PROPOSED_SALARY_WARNING Boolean;
3365: L_APPROVED_WARNING Boolean;

Line 3362: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

3358: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3359: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3360: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3361: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3362: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3363: L_INV_NEXT_SAL_DATE_WARNING Boolean;
3364: L_PROPOSED_SALARY_WARNING Boolean;
3365: L_APPROVED_WARNING Boolean;
3366: l_salary_change_date date;