APPS.PQH_EMPLOYEE_SALARY dependencies on BEN_PER_IN_LER

Line 540: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;

536: l_person_id Per_All_Assignments_f.person_id%type;
537: l_payroll_id Per_All_Assignments_f.payroll_id%type;
538: --
539: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;
540: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;
541: --
542: l_continue boolean;
543: l_proc varchar2(72);
544: --

Line 561: From Ben_Per_in_ler PIL,

557: Between pgm.Effective_Start_date and pgm.Effective_End_Date;
558: --
559: Cursor csr_le is
560: Select max(pil.Per_in_Ler_Id)
561: From Ben_Per_in_ler PIL,
562: Ben_Ler_F LER
563: Where Pil.Ler_Id = LER.Ler_Id
564: And Pil.LF_EVT_OCRD_DT = P_Effective_Date
565: And ler.typ_Cd = 'GSP'