eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_UTILITY dependencies on BEN_PGM_F

Line 83: ben_pgm_f bpgm,

79: select
80: pg.name
81: ,bpgm.name
82: from
83: ben_pgm_f bpgm,
84: ben_pl_f bp,
85: BEN_PL_TYP_F bpt,
86: ben_plip_f bplip,
87: per_grade_spines_f pgs,

Line 101: l_pgm_name ben_pgm_f.name%type;

97: and pg.grade_id = pgs.grade_id;
98: --
99:
100: l_gname per_grades.name%type;
101: l_pgm_name ben_pgm_f.name%type;
102:
103: l_proc varchar2(72) := g_package||'chk_ps_for_upd_del';
104:
105: begin

Line 139: ben_pgm_f bpgm,

135: select
136: pg.name
137: ,bpgm.name
138: from
139: ben_pgm_f bpgm,
140: ben_pl_f bp,
141: BEN_PL_TYP_F bpt,
142: ben_plip_f bplip,
143: per_grade_spines_f pgs,

Line 162: l_pgm_name ben_pgm_f.name%type;

158: and pr.name = pps.name
159: and pps.parent_spine_id = pgs.parent_spine_id;
160: --
161: l_gname per_grades.name%type;
162: l_pgm_name ben_pgm_f.name%type;
163: l_proc varchar2(72) := g_package||'chk_rate_for_upd_del';
164: --
165: begin
166: --

Line 338: From ben_pgm_f

334:
335: Cursor csr_default_grdldr
336: IS
337: Select Null
338: From ben_pgm_f
339: Where pgm_id = l_pgm_id
340: And pgm_typ_cd = 'GSP'
341: And Dflt_Pgm_Flag = 'Y'
342: And business_group_id = p_business_group_id

Line 1611: (p_ben_pgm_id IN ben_pgm_f.pgm_id%TYPE,

1607: --
1608: ---------------------------enddate_grade_ladder-----------------------------
1609: --
1610: procedure enddate_grade_ladder
1611: (p_ben_pgm_id IN ben_pgm_f.pgm_id%TYPE,
1612: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS
1613:
1614: Cursor pgm is
1615: select pgm_id, object_version_number from ben_pgm_f where pgm_id = p_ben_pgm_id and effective_end_date = hr_general.end_of_time;

Line 1612: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS

1608: ---------------------------enddate_grade_ladder-----------------------------
1609: --
1610: procedure enddate_grade_ladder
1611: (p_ben_pgm_id IN ben_pgm_f.pgm_id%TYPE,
1612: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS
1613:
1614: Cursor pgm is
1615: select pgm_id, object_version_number from ben_pgm_f where pgm_id = p_ben_pgm_id and effective_end_date = hr_general.end_of_time;
1616:

Line 1615: select pgm_id, object_version_number from ben_pgm_f where pgm_id = p_ben_pgm_id and effective_end_date = hr_general.end_of_time;

1611: (p_ben_pgm_id IN ben_pgm_f.pgm_id%TYPE,
1612: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS
1613:
1614: Cursor pgm is
1615: select pgm_id, object_version_number from ben_pgm_f where pgm_id = p_ben_pgm_id and effective_end_date = hr_general.end_of_time;
1616:
1617: Cursor c2 is
1618: select copy_entity_txn_id from pqh_copy_entity_txns where copy_entity_txn_id in
1619: (select copy_entity_txn_id from ben_copy_entity_results

Line 1760: L_CURRENCY Ben_Pgm_F.Pgm_Uom%TYPE;

1756: L_ANNUAL_SALARY Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1757: L_PAY_BASIS Varchar2(5);
1758: L_REASON_CD Per_pay_Proposals.proposal_reason%TYPE;
1759: l_pay_basis_frequency Per_pay_bases.pay_basis%TYPE;
1760: L_CURRENCY Ben_Pgm_F.Pgm_Uom%TYPE;
1761: L_STATUS Number(10);
1762:
1763: Cursor Sal is
1764: Select pev.screen_entry_value

Line 1790: from Ben_Pgm_f pgm,

1786: and paf.pay_basis_id = ppb.pay_basis_id;
1787:
1788: Cursor GrdLdr_Element is
1789: Select DFLT_INPUT_VALUE_ID
1790: from Ben_Pgm_f pgm,
1791: Per_All_Assignments_f paf
1792: Where paf.Assignment_Id = p_Assignment_Id
1793: and p_Effective_Date
1794: Between Paf.Effective_Start_Date and Paf.Effective_End_Date

Line 1960: l_name Ben_Pgm_F.Name%Type;

1956: for a business group or not.
1957: */
1958:
1959: l_proc varchar2(72) := g_package|| 'chk_default_ladder_exist';
1960: l_name Ben_Pgm_F.Name%Type;
1961: l_dummy Char(1);
1962:
1963: Cursor csr_curr_grdldr IS
1964: Select Name

Line 1965: From ben_pgm_f

1961: l_dummy Char(1);
1962:
1963: Cursor csr_curr_grdldr IS
1964: Select Name
1965: From ben_pgm_f
1966: Where pgm_id = p_pgm_id
1967: And business_group_id = p_business_group_id
1968: And effective_end_date>= p_effective_date
1969: And pgm_typ_cd = 'GSP'

Line 1976: From ben_pgm_f

1972:
1973:
1974: Cursor csr_default_chk IS
1975: Select Null
1976: From ben_pgm_f
1977: Where pgm_id <> nvl(p_pgm_id,-1)
1978: And business_group_id = p_business_group_id
1979: And p_effective_date Between Effective_Start_Date
1980: And nvl(Effective_End_Date, hr_general.end_of_time)

Line 2247: l_old_status BEN_PGM_F.PGM_STAT_CD%Type;

2243: inactivated or not
2244: */
2245:
2246: l_proc Varchar2(72) := g_package|| 'chk_inactivate_grdldr';
2247: l_old_status BEN_PGM_F.PGM_STAT_CD%Type;
2248: l_dummy Char(1);
2249:
2250:
2251: Cursor csr_active_gl IS

Line 2262: From BEN_PGM_F pgm

2258:
2259: Cursor csr_pgm_status
2260: IS
2261: Select pgm.PGM_STAT_CD -- Activate A , Inactivate I
2262: From BEN_PGM_F pgm
2263: Where pgm.Pgm_Id = p_pgm_id
2264: And pgm.Business_Group_Id = p_business_group_id
2265: And p_effective_date between pgm.effective_start_date
2266: And nvl(pgm.effective_end_date, hr_general.end_of_time);

Line 2828: From ben_pgm_f

2824: -- Default Grade Ladder
2825: Cursor csr_default_grdldr
2826: IS
2827: Select Null
2828: From ben_pgm_f
2829: Where pgm_id = p_pgm_id
2830: And pgm_typ_cd = 'GSP'
2831: And Dflt_Pgm_Flag = 'Y'
2832: And business_group_id = p_business_group_id

Line 2992: From Ben_Pgm_F

2988:
2989: Cursor csr_name
2990: IS
2991: Select null
2992: From Ben_Pgm_F
2993: Where Pgm_Id <> nvl(p_pgm_id,-1)
2994: And Name = p_name
2995: And Business_Group_Id = p_business_group_id;
2996:

Line 3041: From Ben_Pgm_F

3037:
3038: Cursor csr_short_name
3039: IS
3040: Select null
3041: From Ben_Pgm_F
3042: Where Pgm_Id <> nvl(p_pgm_id,-1)
3043: And Short_Name = nvl(p_short_name,-1)
3044: And Business_Group_Id = p_business_group_id
3045: And p_short_name IS NOT NULL;

Line 3050: From Ben_Pgm_F

3046:
3047: Cursor csr_short_code
3048: IS
3049: Select null
3050: From Ben_Pgm_F
3051: Where Pgm_Id <> nvl(p_pgm_id,-1)
3052: And Short_Code = nvl(p_short_code,-1)
3053: And Business_Group_Id = p_business_group_id
3054: And p_short_code IS NOT NULL;

Line 3251: Ben_Pgm_F Pgm

3247: Select Pgm.ACTY_REF_PERD_CD, -- Rate
3248: Pgm.Pgm_uom -- Currency
3249: From Ben_Pl_f Pl,
3250: Ben_Plip_F Plip,
3251: Ben_Pgm_F Pgm
3252: Where Pl.MAPPING_TABLE_PK_ID = l_grade_Id
3253: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'
3254: and P_Effective_Date
3255: Between Pl.Effective_Start_Date

Line 3276: l_target_currency Ben_Pgm_F.PGM_UOM%Type;

3272: l_curr_gl_result_id Number;
3273: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3274: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3275:
3276: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3277: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
3278:
3279: l_dummy Varchar2(4000) := null;
3280: l_found Boolean := FALSE;

Line 3277: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;

3273: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3274: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3275:
3276: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3277: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
3278:
3279: l_dummy Varchar2(4000) := null;
3280: l_found Boolean := FALSE;
3281:

Line 3562: From Ben_Pgm_F

3558: IS
3559: Select Name,
3560: Short_Name,
3561: Short_Code
3562: From Ben_Pgm_F
3563: Where Pgm_id Is Not Null
3564: And Pgm_id = p_pgm_id
3565: And Business_Group_Id = p_business_group_id;
3566:

Line 3578: l_name Ben_Pgm_F.Name%Type;

3574: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
3575: And Information_Category = 'GRADE_LADDER';
3576:
3577:
3578: l_name Ben_Pgm_F.Name%Type;
3579: l_short_name Ben_Pgm_F.Short_Name%Type;
3580: l_short_code Ben_Pgm_F.Short_Code%Type;
3581: l_status Varchar2(20) := 'E';
3582: l_error_status Varchar2(20) := 'E';

Line 3579: l_short_name Ben_Pgm_F.Short_Name%Type;

3575: And Information_Category = 'GRADE_LADDER';
3576:
3577:
3578: l_name Ben_Pgm_F.Name%Type;
3579: l_short_name Ben_Pgm_F.Short_Name%Type;
3580: l_short_code Ben_Pgm_F.Short_Code%Type;
3581: l_status Varchar2(20) := 'E';
3582: l_error_status Varchar2(20) := 'E';
3583: l_grdldr_date Date;

Line 3580: l_short_code Ben_Pgm_F.Short_Code%Type;

3576:
3577:
3578: l_name Ben_Pgm_F.Name%Type;
3579: l_short_name Ben_Pgm_F.Short_Name%Type;
3580: l_short_code Ben_Pgm_F.Short_Code%Type;
3581: l_status Varchar2(20) := 'E';
3582: l_error_status Varchar2(20) := 'E';
3583: l_grdldr_date Date;
3584:

Line 4111: From Ben_Pgm_f Pgm,

4107: CURSOR C_Pgm_rt_Perd IS
4108: Select Pgm.ACTY_REF_PERD_CD,
4109: Nvl(Cur.Precision,2),
4110: Update_Salary_Cd
4111: From Ben_Pgm_f Pgm,
4112: Fnd_Currencies Cur
4113: Where Pgm.Pgm_id = P_Pgm_Id
4114: and P_Effective_Date
4115: Between Pgm.Effective_Start_Date

Line 4129: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;

4125: between Asg.Effective_Start_Date
4126: and Asg.Effective_End_Date
4127: and Ppb.Pay_Basis_Id = Asg.Pay_Basis_Id;
4128:
4129: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4130: l_precision Fnd_Currencies.Precision%TYPE;
4131: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4132: l_ret_amount Number;
4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

Line 4134: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

4130: l_precision Fnd_Currencies.Precision%TYPE;
4131: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4132: l_ret_amount Number;
4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4134: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4135: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4136: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4137: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
4138:

Line 4644: from ben_pgm_f pgm

4640: -- Declare cursor
4641: --
4642: cursor csr_chk_gsp_in_system is
4643: select 'x'
4644: from ben_pgm_f pgm
4645: where pgm.business_group_id = p_asg_bg_id
4646: and pgm.pgm_typ_cd = 'GSP'
4647: and p_effective_date
4648: between pgm.effective_start_date

Line 5226: from ben_pgm_f

5222: where pl_id = p_pl_id;
5223: Cursor Csr_Use_Points(p_pgm_id IN NUMBER)
5224: is
5225: select USE_PROG_POINTS_FLAG
5226: from ben_pgm_f
5227: where pgm_id = p_pgm_id;
5228: begin
5229: if g_debug then
5230: hr_utility.set_location('Entering chk_from_steps : ',10);

Line 5696: FROM ben_pgm_f

5692: IS
5693: CURSOR csr_name
5694: IS
5695: SELECT NULL
5696: FROM ben_pgm_f
5697: WHERE NAME = p_name
5698: AND business_group_id = p_business_group_id
5699: AND pgm_id <> NVL (p_pgm_id, -1);
5700:

Line 5704: FROM ben_pgm_f

5700:
5701: CURSOR csr_dflt_grd_ldr
5702: IS
5703: SELECT NAME
5704: FROM ben_pgm_f
5705: WHERE dflt_pgm_flag = 'Y'
5706: AND business_group_id = p_business_group_id
5707: AND pgm_id <> NVL (p_pgm_id, -1)
5708: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 5710: l_pgm_name ben_pgm_f.NAME%TYPE;

5706: AND business_group_id = p_business_group_id
5707: AND pgm_id <> NVL (p_pgm_id, -1)
5708: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
5709:
5710: l_pgm_name ben_pgm_f.NAME%TYPE;
5711: l_dummy VARCHAR2 (10);
5712: BEGIN
5713: hr_multi_message.enable_message_list;
5714: