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_PRTT_ENRT_RSLT_F

Line 1362: l_PRTT_ENRT_RSLT_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;

1358: Ben_Enrt_Rt Rate
1359: Where Elctbl.ELIG_PER_ELCTBL_CHC_ID = P_ELIG_PER_ELCTBL_CHC_ID
1360: and Rate.ELIG_PER_ELCTBL_CHC_ID = Elctbl.ELIG_PER_ELCTBL_CHC_ID;
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;

Line 1363: l_Ovn_No BEN_PRTT_ENRT_RSLT_F.Object_Version_Number%TYPE;

1359: Where Elctbl.ELIG_PER_ELCTBL_CHC_ID = P_ELIG_PER_ELCTBL_CHC_ID
1360: and Rate.ELIG_PER_ELCTBL_CHC_ID = Elctbl.ELIG_PER_ELCTBL_CHC_ID;
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);

Line 1364: L_PRTT_ENRT_INTERIM_ID BEN_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;

1360: and Rate.ELIG_PER_ELCTBL_CHC_ID = Elctbl.ELIG_PER_ELCTBL_CHC_ID;
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';

Line 1766: From Ben_PRTT_ENRT_RSLT_F Enrt,

1762: /* Cursor Enroll_Info is
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

Line 2334: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;

2330: l_PLACEMENT_ID Per_Spinal_Point_Placements_F.PLacement_Id%TYPE;
2331: l_Placement_Ovn Per_Spinal_Point_Placements_F.Object_Version_Number%TYPE;
2332: l_Effective_Start_Date Per_Spinal_Point_Placements_F.Effective_Start_Date%TYPE;
2333: l_Effective_End_Date Per_Spinal_Point_Placements_F.Effective_End_Date%TYPE;
2334: l_Business_Group_Id Ben_PRTT_ENRT_RSLT_F.Business_Group_Id%TYPE;
2335: l_group_name Varchar2(250);
2336: l_Asg_effective_start_date Per_All_Assignments_F.Effective_Start_Date%TYPE;
2337: l_Asg_effective_end_date Per_All_Assignments_F.Effective_End_Date%TYPE;
2338: l_org_now_no_manager_warning Boolean;

Line 2495: -- L_PRTT_ENRT_RSLT_ID Ben_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;

2491: P_Elig_per_Elctbl_Chc_Id IN Number) Is
2492:
2493:
2494: l_Error_Status varchar2(30);
2495: -- L_PRTT_ENRT_RSLT_ID Ben_PRTT_ENRT_RSLT_F.PRTT_ENRT_RSLT_ID%TYPE;
2496: L_INV_NEXT_SAL_DATE_WARNING Boolean;
2497: L_PROPOSED_SALARY_WARNING Boolean;
2498: L_APPROVED_WARNING Boolean;
2499: L_PAYROLL_WARNING Boolean;