APPS.PQH_GSP_DEFAULT dependencies on BEN_PGM_F

Line 771: l_gl_name ben_pgm_f.name%type;

767: l_grade_id number;
768: l_spl_ceiling_id number;
769: l_prog_style_cd varchar2(30);
770: l_post_style_cd varchar2(30);
771: l_gl_name ben_pgm_f.name%type;
772: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type;
773: l_dflt_step_rl ben_pgm_f.dflt_step_rl%type;
774: l_continue boolean := TRUE;
775: l_scale_id number;

Line 772: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type;

768: l_spl_ceiling_id number;
769: l_prog_style_cd varchar2(30);
770: l_post_style_cd varchar2(30);
771: l_gl_name ben_pgm_f.name%type;
772: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type;
773: l_dflt_step_rl ben_pgm_f.dflt_step_rl%type;
774: l_continue boolean := TRUE;
775: l_scale_id number;
776: l_scale_ovn number;

Line 773: l_dflt_step_rl ben_pgm_f.dflt_step_rl%type;

769: l_prog_style_cd varchar2(30);
770: l_post_style_cd varchar2(30);
771: l_gl_name ben_pgm_f.name%type;
772: l_dflt_step_cd ben_pgm_f.dflt_step_cd%type;
773: l_dflt_step_rl ben_pgm_f.dflt_step_rl%type;
774: l_continue boolean := TRUE;
775: l_scale_id number;
776: l_scale_ovn number;
777: l_scale_name per_parent_spines.name%type;

Line 1010: from ben_pgm_f

1006: begin
1007: hr_utility.set_location('bg is'||p_business_group_id,5);
1008: select pgm_id
1009: into l_gl_id
1010: from ben_pgm_f
1011: where p_effective_date between effective_start_date and effective_end_date
1012: and pgm_stat_cd ='A' -- active program
1013: and pgm_typ_cd ='GSP' -- context should be GSP
1014: and dflt_pgm_flag = 'Y' -- default

Line 1039: from ben_pgm_f

1035: p_dflt_step_rl out nocopy varchar2) is
1036: begin
1037: select enrt_mthd_cd,name,dflt_step_cd,dflt_step_rl
1038: into p_post_style_cd,p_gl_name,p_dflt_step_cd,p_dflt_step_rl
1039: from ben_pgm_f
1040: where pgm_id = p_gl_id
1041: and pgm_stat_cd ='A' -- program should be active
1042: and p_effective_date between effective_start_date and effective_end_date
1043: and pgm_typ_cd ='GSP' ;-- should be Grade ladder

Line 1080: from Ben_Pgm_f pgm,

1076: and p_Effective_Date Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1077: and paf.pay_basis_id = ppb.pay_basis_id;
1078: Cursor GrdLdr_Element is
1079: Select DFLT_INPUT_VALUE_ID
1080: from Ben_Pgm_f pgm,
1081: Per_All_Assignments_f paf
1082: Where paf.Assignment_Id = p_Assignment_Id
1083: and p_Effective_Date
1084: Between Paf.Effective_Start_Date and Paf.Effective_End_Date

Line 1276: from Ben_Pgm_f pgm,

1272: and paf.pay_basis_id = ppb.pay_basis_id;
1273:
1274: Cursor GrdLdr_Element is
1275: Select DFLT_INPUT_VALUE_ID
1276: from Ben_Pgm_f pgm,
1277: Per_All_Assignments_f paf
1278: Where paf.Assignment_Id = p_Assignment_Id
1279: and p_Effective_Date
1280: Between Paf.Effective_Start_Date and Paf.Effective_End_Date