APPS.PQH_EMPLOYEE_SALARY dependencies on BEN_PER_IN_LER

Line 462: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;

458: l_person_id Per_All_Assignments_f.person_id%type;
459: l_payroll_id Per_All_Assignments_f.payroll_id%type;
460: --
461: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;
462: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;
463: --
464: l_continue boolean;
465: l_proc varchar2(72);
466: --

Line 483: From Ben_Per_in_ler PIL,

479: Between pgm.Effective_Start_date and pgm.Effective_End_Date;
480: --
481: Cursor csr_le is
482: Select max(pil.Per_in_Ler_Id)
483: From Ben_Per_in_ler PIL,
484: Ben_Ler_F LER
485: Where Pil.Ler_Id = LER.Ler_Id
486: And Pil.LF_EVT_OCRD_DT = P_Effective_Date
487: And ler.typ_Cd = 'GSP'