APPS.PQH_EMPLOYEE_SALARY dependencies on BEN_PGM_F

Line 76: from Ben_Pgm_f pgm

72: Where paf.pay_basis_id = l_pay_basis_id;
73: --
74: Cursor GrdLdr_Element is
75: Select DFLT_INPUT_VALUE_ID
76: from Ben_Pgm_f pgm
77: Where pgm.pgm_id = l_pgm_id
78: and p_Effective_Date
79: Between pgm.Effective_Start_date and pgm.Effective_End_Date;
80: --

Line 299: from ben_pgm_f

295: is
296: --
297: Cursor csr_gsp is
298: Select 'x'
299: from ben_pgm_f
300: Where business_group_id = p_business_group_id
301: and pgm_typ_cd = 'GSP'
302: and p_effective_date between effective_start_date and effective_end_date;
303: --

Line 532: l_update_sal_cd ben_pgm_f.update_salary_cd%type;

528: p_status OUT nocopy number
529: ) IS
530: --
531: L_Cur_Sal Ben_Enrt_Rt.val%type;
532: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
533: --
534: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
535: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
536: l_person_id Per_All_Assignments_f.person_id%type;

Line 539: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;

535: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_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);

Line 554: from Ben_Pgm_f pgm

550: Between Paf.Effective_Start_Date and Paf.Effective_End_Date;
551: --
552: Cursor csr_GrdLdr is
553: Select ACTY_REF_PERD_CD,pgm_uom,Update_Salary_Cd
554: from Ben_Pgm_f pgm
555: Where pgm.pgm_id = l_pgm_id
556: and p_Effective_Date
557: Between pgm.Effective_Start_date and pgm.Effective_End_Date;
558: --