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 HR_GENERAL

Line 201: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

197: From per_all_assignments_f assgt
198: Where grade_id = l_grade_id
199: AND Grade_Ladder_Pgm_Id = l_pgm_id
200: AND p_Effective_Date BETWEEN assgt.effective_start_date
201: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
202: AND assgt.business_group_id = p_Business_Group_Id;
203:
204:
205: -- Check Grade is attached to an employee

Line 212: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

208: Select Null
209: From per_all_assignments_f assgt
210: Where grade_id = l_grade_id
211: AND p_Effective_Date BETWEEN assgt.effective_start_date
212: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
213: AND assgt.business_group_id = p_Business_Group_Id;
214:
215:
216: Cursor csr_default_grdldr

Line 225: And nvl(Effective_End_Date,hr_general.end_of_time);

221: And pgm_typ_cd = 'GSP'
222: And Dflt_Pgm_Flag = 'Y'
223: And business_group_id = p_business_group_id
224: And p_Effective_Date Between Effective_Start_date
225: And nvl(Effective_End_Date,hr_general.end_of_time);
226:
227: Cursor csr_grade_crpath_node
228: IS
229: select null

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 1861: And nvl(Effective_End_Date, hr_general.end_of_time)

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)
1862: And pgm_typ_cd = 'GSP'
1863: And Dflt_Pgm_Flag = 'Y';
1864: --
1865: Begin

Line 2077: AND nvl(grd.Information307,hr_general.end_of_time)

2073: AND grd.Table_Alias = 'CPP'
2074: AND nvl(grd.Information104,'PPP') <> 'UNLINK'
2075: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2076: AND p_effective_date Not BETWEEN grd.Information306
2077: AND nvl(grd.Information307,hr_general.end_of_time)
2078: AND Information4 = p_business_group_id;
2079: BEGIN
2080: if g_debug then
2081: hr_utility.set_location('Entering:'||l_proc,10);

Line 2137: And nvl(effective_end_date, hr_general.end_of_time)

2133: Select null
2134: From Per_All_Assignments_F
2135: Where Grade_Ladder_Pgm_Id = p_pgm_id
2136: And p_effective_date between effective_start_date
2137: And nvl(effective_end_date, hr_general.end_of_time)
2138: And Business_Group_Id = p_business_group_id;
2139:
2140: Cursor csr_pgm_status
2141: IS

Line 2147: And nvl(pgm.effective_end_date, hr_general.end_of_time);

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);
2148:
2149:
2150:
2151: Begin

Line 2691: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

2687: From per_all_assignments_f assgt
2688: Where grade_id = l_grade_id
2689: AND Grade_Ladder_Pgm_Id = p_pgm_id
2690: AND p_Effective_Date BETWEEN assgt.effective_start_date
2691: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
2692: AND assgt.business_group_id = p_Business_Group_Id;
2693:
2694:
2695: -- Check Grade is attached to an employee

Line 2702: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

2698: Select Null
2699: From per_all_assignments_f assgt
2700: Where grade_id = l_grade_id
2701: AND p_Effective_Date BETWEEN assgt.effective_start_date
2702: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
2703: AND assgt.business_group_id = p_Business_Group_Id;
2704:
2705: -- Default Grade Ladder
2706: Cursor csr_default_grdldr

Line 2715: And nvl(Effective_End_Date,hr_general.end_of_time);

2711: And pgm_typ_cd = 'GSP'
2712: And Dflt_Pgm_Flag = 'Y'
2713: And business_group_id = p_business_group_id
2714: And p_Effective_Date Between Effective_Start_date
2715: And nvl(Effective_End_Date,hr_general.end_of_time);
2716:
2717: BEGIN
2718: if g_debug then
2719: hr_utility.set_location('Entering:'||l_proc, 5);

Line 3137: and Nvl(Pl.Effective_End_Date,hr_general.end_of_time)

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
3137: and Nvl(Pl.Effective_End_Date,hr_general.end_of_time)
3138: and Plip.Pl_Id = Pl.Pl_Id
3139: and P_Effective_Date
3140: Between Plip.Effective_Start_Date
3141: and Nvl(Plip.Effective_End_Date,hr_general.end_of_time)

Line 3141: and Nvl(Plip.Effective_End_Date,hr_general.end_of_time)

3137: and Nvl(Pl.Effective_End_Date,hr_general.end_of_time)
3138: and Plip.Pl_Id = Pl.Pl_Id
3139: and P_Effective_Date
3140: Between Plip.Effective_Start_Date
3141: and Nvl(Plip.Effective_End_Date,hr_general.end_of_time)
3142: and Plip.Pgm_Id = Pgm.Pgm_Id
3143: and P_Effective_Date
3144: Between Pgm.Effective_Start_Date
3145: and Nvl(Pgm.Effective_End_Date,hr_general.end_of_time)

Line 3145: and Nvl(Pgm.Effective_End_Date,hr_general.end_of_time)

3141: and Nvl(Plip.Effective_End_Date,hr_general.end_of_time)
3142: and Plip.Pgm_Id = Pgm.Pgm_Id
3143: and P_Effective_Date
3144: Between Pgm.Effective_Start_Date
3145: and Nvl(Pgm.Effective_End_Date,hr_general.end_of_time)
3146: and pgm.Business_group_id = p_Business_Group_Id
3147: and (pgm.ACTY_REF_PERD_CD <> l_rate
3148: or pgm.Pgm_Uom <> l_currency)
3149: and Pgm_Typ_Cd = 'GSP'

Line 3845: ,p_name => hr_general.decode_lookup('PQH_GSP_GEN_PAY_RATE_NAME',p_ldr_period_code)

3841: hr_rate_api.create_rate
3842: (p_validate => false
3843: ,p_effective_date => trunc(sysdate)
3844: ,p_business_group_id => p_business_group_id
3845: ,p_name => hr_general.decode_lookup('PQH_GSP_GEN_PAY_RATE_NAME',p_ldr_period_code)
3846: ,p_rate_type => 'G'
3847: ,p_rate_uom => 'M'
3848: ,p_object_version_number => l_ovn
3849: ,p_rate_id => l_rate_id);

Line 4966: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);

4962: where table_alias ='PLN'
4963: and result_type_cd = 'DISPLAY'
4964: and gs_mirror_src_entity_result_id = p_copy_entity_result_id)
4965: and table_alias = 'HRRATE' and l_action_dt
4966: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);
4967:
4968: Cursor Csr_Action_Dt is
4969: Select Action_Date
4970: From Pqh_Copy_Entity_txns

Line 4988: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);

4984: and information278 = point_cer_id
4985: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4986: and table_alias = 'HRRATE' and l_action_dt
4987:
4988: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);
4989:
4990: l_point_cer_id number := -1;
4991: l_action_date date;
4992: cnt number := 0;

Line 5325: ,P_EFFECTIVE_DATE => Nvl(L_Action_Date, hr_general.Effective_Date));

5321: where copy_entity_result_id = rec_steps.copy_entity_result_id; */
5322:
5323: Pqh_Gsp_Grd_Step_Remove.REMOVE_OIPL(P_COPY_ENTITY_TXN_ID => p_copy_entity_txn_id
5324: ,P_COPY_ENTITY_RESULT_ID => rec_steps.copy_entity_result_id
5325: ,P_EFFECTIVE_DATE => Nvl(L_Action_Date, hr_general.Effective_Date));
5326:
5327: end loop;
5328:
5329:

Line 5563: return Hr_General.DEFAULT_CURRENCY_CODE(p_Business_group_Id);

5559: --
5560: FUNCTION get_bg_currency(p_business_group_id in number) RETURN varchar2
5561: is
5562: begin
5563: return Hr_General.DEFAULT_CURRENCY_CODE(p_Business_group_Id);
5564: end get_bg_currency;
5565: --
5566: PROCEDURE chk_grd_ldr_details (
5567: p_business_group_id IN NUMBER,