DBA Data[Home] [Help]

APPS.PQH_EMPLOYEE_SALARY dependencies on BEN_ENRT_RT

Line 453: L_Cur_Sal Ben_Enrt_Rt.val%type;

449: p_currency OUT nocopy varchar2,
450: p_status OUT nocopy number
451: ) IS
452: --
453: L_Cur_Sal Ben_Enrt_Rt.val%type;
454: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
455: --
456: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
457: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;

Line 495: Ben_Enrt_Rt Rate

491: Cursor csr_sal is
492: Select Rate.Val Proposed_Sal,
493: Rate.Rt_Strt_Dt Sal_Chg_Dt
494: From Ben_Elig_Per_Elctbl_Chc Elct,
495: Ben_Enrt_Rt Rate
496: Where Elct.DFLT_FLAG = 'Y'
497: and Elct.Elctbl_Flag = 'Y'
498: and Elct.Per_in_ler_id = l_per_in_ler_id
499: and Elct.Enrt_Cvg_Strt_Dt is Not NULL