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 219: From ben_pgm_f

215:
216: Cursor csr_default_grdldr
217: IS
218: Select Null
219: From ben_pgm_f
220: Where pgm_id = l_pgm_id
221: And pgm_typ_cd = 'GSP'
222: And Dflt_Pgm_Flag = 'Y'
223: And business_group_id = p_business_group_id

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

1488: --
1489: ---------------------------enddate_grade_ladder-----------------------------
1490: --
1491: procedure enddate_grade_ladder
1492: (p_ben_pgm_id IN ben_pgm_f.pgm_id%TYPE,
1493: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS
1494:
1495: Cursor pgm is
1496: 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 1493: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS

1489: ---------------------------enddate_grade_ladder-----------------------------
1490: --
1491: procedure enddate_grade_ladder
1492: (p_ben_pgm_id IN ben_pgm_f.pgm_id%TYPE,
1493: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS
1494:
1495: Cursor pgm is
1496: 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;
1497:

Line 1496: 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;

1492: (p_ben_pgm_id IN ben_pgm_f.pgm_id%TYPE,
1493: p_effective_date_in IN ben_pgm_f.effective_start_date%TYPE) IS
1494:
1495: Cursor pgm is
1496: 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;
1497:
1498: Cursor c2 is
1499: select copy_entity_txn_id from pqh_copy_entity_txns where copy_entity_txn_id in
1500: (select copy_entity_txn_id from ben_copy_entity_results

Line 1641: L_CURRENCY Ben_Pgm_F.Pgm_Uom%TYPE;

1637: L_ANNUAL_SALARY Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1638: L_PAY_BASIS Varchar2(5);
1639: L_REASON_CD Per_pay_Proposals.proposal_reason%TYPE;
1640: l_pay_basis_frequency Per_pay_bases.pay_basis%TYPE;
1641: L_CURRENCY Ben_Pgm_F.Pgm_Uom%TYPE;
1642: L_STATUS Number(10);
1643:
1644: Cursor Sal is
1645: Select pev.screen_entry_value

Line 1671: from Ben_Pgm_f pgm,

1667: and paf.pay_basis_id = ppb.pay_basis_id;
1668:
1669: Cursor GrdLdr_Element is
1670: Select DFLT_INPUT_VALUE_ID
1671: from Ben_Pgm_f pgm,
1672: Per_All_Assignments_f paf
1673: Where paf.Assignment_Id = p_Assignment_Id
1674: and p_Effective_Date
1675: Between Paf.Effective_Start_Date and Paf.Effective_End_Date

Line 1841: l_name Ben_Pgm_F.Name%Type;

1837: for a business group or not.
1838: */
1839:
1840: l_proc varchar2(72) := g_package|| 'chk_default_ladder_exist';
1841: l_name Ben_Pgm_F.Name%Type;
1842: l_dummy Char(1);
1843:
1844: Cursor csr_curr_grdldr IS
1845: Select Name

Line 1846: From ben_pgm_f

1842: l_dummy Char(1);
1843:
1844: Cursor csr_curr_grdldr IS
1845: Select Name
1846: From ben_pgm_f
1847: Where pgm_id = p_pgm_id
1848: And business_group_id = p_business_group_id
1849: And effective_end_date>= p_effective_date
1850: And pgm_typ_cd = 'GSP'

Line 1857: From ben_pgm_f

1853:
1854:
1855: Cursor csr_default_chk IS
1856: Select Null
1857: From ben_pgm_f
1858: Where pgm_id <> nvl(p_pgm_id,-1)
1859: And business_group_id = p_business_group_id
1860: And p_effective_date Between Effective_Start_Date
1861: And nvl(Effective_End_Date, hr_general.end_of_time)

Line 2128: l_old_status BEN_PGM_F.PGM_STAT_CD%Type;

2124: inactivated or not
2125: */
2126:
2127: l_proc Varchar2(72) := g_package|| 'chk_inactivate_grdldr';
2128: l_old_status BEN_PGM_F.PGM_STAT_CD%Type;
2129: l_dummy Char(1);
2130:
2131:
2132: Cursor csr_active_gl IS

Line 2143: From BEN_PGM_F pgm

2139:
2140: Cursor csr_pgm_status
2141: IS
2142: Select pgm.PGM_STAT_CD -- Activate A , Inactivate I
2143: From BEN_PGM_F pgm
2144: Where pgm.Pgm_Id = p_pgm_id
2145: And pgm.Business_Group_Id = p_business_group_id
2146: And p_effective_date between pgm.effective_start_date
2147: And nvl(pgm.effective_end_date, hr_general.end_of_time);

Line 2709: From ben_pgm_f

2705: -- Default Grade Ladder
2706: Cursor csr_default_grdldr
2707: IS
2708: Select Null
2709: From ben_pgm_f
2710: Where pgm_id = p_pgm_id
2711: And pgm_typ_cd = 'GSP'
2712: And Dflt_Pgm_Flag = 'Y'
2713: And business_group_id = p_business_group_id

Line 2873: From Ben_Pgm_F

2869:
2870: Cursor csr_name
2871: IS
2872: Select null
2873: From Ben_Pgm_F
2874: Where Pgm_Id <> nvl(p_pgm_id,-1)
2875: And Name = p_name
2876: And Business_Group_Id = p_business_group_id;
2877:

Line 2922: From Ben_Pgm_F

2918:
2919: Cursor csr_short_name
2920: IS
2921: Select null
2922: From Ben_Pgm_F
2923: Where Pgm_Id <> nvl(p_pgm_id,-1)
2924: And Short_Name = nvl(p_short_name,-1)
2925: And Business_Group_Id = p_business_group_id
2926: And p_short_name IS NOT NULL;

Line 2931: From Ben_Pgm_F

2927:
2928: Cursor csr_short_code
2929: IS
2930: Select null
2931: From Ben_Pgm_F
2932: Where Pgm_Id <> nvl(p_pgm_id,-1)
2933: And Short_Code = nvl(p_short_code,-1)
2934: And Business_Group_Id = p_business_group_id
2935: And p_short_code IS NOT NULL;

Line 3132: Ben_Pgm_F Pgm

3128: Select Pgm.ACTY_REF_PERD_CD, -- Rate
3129: Pgm.Pgm_uom -- Currency
3130: From Ben_Pl_f Pl,
3131: Ben_Plip_F Plip,
3132: Ben_Pgm_F Pgm
3133: Where Pl.MAPPING_TABLE_PK_ID = l_grade_Id
3134: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'
3135: and P_Effective_Date
3136: Between Pl.Effective_Start_Date

Line 3157: l_target_currency Ben_Pgm_F.PGM_UOM%Type;

3153: l_curr_gl_result_id Number;
3154: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3155: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3156:
3157: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3158: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
3159:
3160: l_dummy Varchar2(4000) := null;
3161: l_found Boolean := FALSE;

Line 3158: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;

3154: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3155: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3156:
3157: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3158: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
3159:
3160: l_dummy Varchar2(4000) := null;
3161: l_found Boolean := FALSE;
3162:

Line 3443: From Ben_Pgm_F

3439: IS
3440: Select Name,
3441: Short_Name,
3442: Short_Code
3443: From Ben_Pgm_F
3444: Where Pgm_id Is Not Null
3445: And Pgm_id = p_pgm_id
3446: And Business_Group_Id = p_business_group_id;
3447:

Line 3459: l_name Ben_Pgm_F.Name%Type;

3455: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
3456: And Information_Category = 'GRADE_LADDER';
3457:
3458:
3459: l_name Ben_Pgm_F.Name%Type;
3460: l_short_name Ben_Pgm_F.Short_Name%Type;
3461: l_short_code Ben_Pgm_F.Short_Code%Type;
3462: l_status Varchar2(20) := 'E';
3463: l_error_status Varchar2(20) := 'E';

Line 3460: l_short_name Ben_Pgm_F.Short_Name%Type;

3456: And Information_Category = 'GRADE_LADDER';
3457:
3458:
3459: l_name Ben_Pgm_F.Name%Type;
3460: l_short_name Ben_Pgm_F.Short_Name%Type;
3461: l_short_code Ben_Pgm_F.Short_Code%Type;
3462: l_status Varchar2(20) := 'E';
3463: l_error_status Varchar2(20) := 'E';
3464: l_grdldr_date Date;

Line 3461: l_short_code Ben_Pgm_F.Short_Code%Type;

3457:
3458:
3459: l_name Ben_Pgm_F.Name%Type;
3460: l_short_name Ben_Pgm_F.Short_Name%Type;
3461: l_short_code Ben_Pgm_F.Short_Code%Type;
3462: l_status Varchar2(20) := 'E';
3463: l_error_status Varchar2(20) := 'E';
3464: l_grdldr_date Date;
3465:

Line 3992: From Ben_Pgm_f Pgm,

3988: CURSOR C_Pgm_rt_Perd IS
3989: Select Pgm.ACTY_REF_PERD_CD,
3990: Nvl(Cur.Precision,2),
3991: Update_Salary_Cd
3992: From Ben_Pgm_f Pgm,
3993: Fnd_Currencies Cur
3994: Where Pgm.Pgm_id = P_Pgm_Id
3995: and P_Effective_Date
3996: Between Pgm.Effective_Start_Date

Line 4010: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;

4006: between Asg.Effective_Start_Date
4007: and Asg.Effective_End_Date
4008: and Ppb.Pay_Basis_Id = Asg.Pay_Basis_Id;
4009:
4010: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4011: l_precision Fnd_Currencies.Precision%TYPE;
4012: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4013: l_ret_amount Number;
4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

Line 4015: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;

4011: l_precision Fnd_Currencies.Precision%TYPE;
4012: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4013: l_ret_amount Number;
4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4015: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4016: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4017: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4018: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
4019:

Line 4525: from ben_pgm_f pgm

4521: -- Declare cursor
4522: --
4523: cursor csr_chk_gsp_in_system is
4524: select 'x'
4525: from ben_pgm_f pgm
4526: where pgm.business_group_id = p_asg_bg_id
4527: and pgm.pgm_typ_cd = 'GSP'
4528: and p_effective_date
4529: between pgm.effective_start_date

Line 5107: from ben_pgm_f

5103: where pl_id = p_pl_id;
5104: Cursor Csr_Use_Points(p_pgm_id IN NUMBER)
5105: is
5106: select USE_PROG_POINTS_FLAG
5107: from ben_pgm_f
5108: where pgm_id = p_pgm_id;
5109: begin
5110: if g_debug then
5111: hr_utility.set_location('Entering chk_from_steps : ',10);

Line 5577: FROM ben_pgm_f

5573: IS
5574: CURSOR csr_name
5575: IS
5576: SELECT NULL
5577: FROM ben_pgm_f
5578: WHERE NAME = p_name
5579: AND business_group_id = p_business_group_id
5580: AND pgm_id <> NVL (p_pgm_id, -1);
5581:

Line 5585: FROM ben_pgm_f

5581:
5582: CURSOR csr_dflt_grd_ldr
5583: IS
5584: SELECT NAME
5585: FROM ben_pgm_f
5586: WHERE dflt_pgm_flag = 'Y'
5587: AND business_group_id = p_business_group_id
5588: AND pgm_id <> NVL (p_pgm_id, -1)
5589: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 5591: l_pgm_name ben_pgm_f.NAME%TYPE;

5587: AND business_group_id = p_business_group_id
5588: AND pgm_id <> NVL (p_pgm_id, -1)
5589: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
5590:
5591: l_pgm_name ben_pgm_f.NAME%TYPE;
5592: l_dummy VARCHAR2 (10);
5593: BEGIN
5594: hr_multi_message.enable_message_list;
5595: