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 320: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

316: From per_all_assignments_f assgt
317: Where grade_id = l_grade_id
318: AND Grade_Ladder_Pgm_Id = l_pgm_id
319: AND p_Effective_Date BETWEEN assgt.effective_start_date
320: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
321: AND assgt.business_group_id = p_Business_Group_Id;
322:
323:
324: -- Check Grade is attached to an employee

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

327: Select Null
328: From per_all_assignments_f assgt
329: Where grade_id = l_grade_id
330: AND p_Effective_Date BETWEEN assgt.effective_start_date
331: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
332: AND assgt.business_group_id = p_Business_Group_Id;
333:
334:
335: Cursor csr_default_grdldr

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

340: And pgm_typ_cd = 'GSP'
341: And Dflt_Pgm_Flag = 'Y'
342: And business_group_id = p_business_group_id
343: And p_Effective_Date Between Effective_Start_date
344: And nvl(Effective_End_Date,hr_general.end_of_time);
345:
346: Cursor csr_grade_crpath_node
347: IS
348: select null

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

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)
1981: And pgm_typ_cd = 'GSP'
1982: And Dflt_Pgm_Flag = 'Y';
1983: --
1984: Begin

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

2192: AND grd.Table_Alias = 'CPP'
2193: AND nvl(grd.Information104,'PPP') <> 'UNLINK'
2194: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2195: AND p_effective_date Not BETWEEN grd.Information306
2196: AND nvl(grd.Information307,hr_general.end_of_time)
2197: AND Information4 = p_business_group_id;
2198: BEGIN
2199: if g_debug then
2200: hr_utility.set_location('Entering:'||l_proc,10);

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

2252: Select null
2253: From Per_All_Assignments_F
2254: Where Grade_Ladder_Pgm_Id = p_pgm_id
2255: And p_effective_date between effective_start_date
2256: And nvl(effective_end_date, hr_general.end_of_time)
2257: And Business_Group_Id = p_business_group_id;
2258:
2259: Cursor csr_pgm_status
2260: IS

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

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);
2267:
2268:
2269:
2270: Begin

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

2806: From per_all_assignments_f assgt
2807: Where grade_id = l_grade_id
2808: AND Grade_Ladder_Pgm_Id = p_pgm_id
2809: AND p_Effective_Date BETWEEN assgt.effective_start_date
2810: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
2811: AND assgt.business_group_id = p_Business_Group_Id;
2812:
2813:
2814: -- Check Grade is attached to an employee

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

2817: Select Null
2818: From per_all_assignments_f assgt
2819: Where grade_id = l_grade_id
2820: AND p_Effective_Date BETWEEN assgt.effective_start_date
2821: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
2822: AND assgt.business_group_id = p_Business_Group_Id;
2823:
2824: -- Default Grade Ladder
2825: Cursor csr_default_grdldr

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

2830: And pgm_typ_cd = 'GSP'
2831: And Dflt_Pgm_Flag = 'Y'
2832: And business_group_id = p_business_group_id
2833: And p_Effective_Date Between Effective_Start_date
2834: And nvl(Effective_End_Date,hr_general.end_of_time);
2835:
2836: BEGIN
2837: if g_debug then
2838: hr_utility.set_location('Entering:'||l_proc, 5);

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

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
3256: and Nvl(Pl.Effective_End_Date,hr_general.end_of_time)
3257: and Plip.Pl_Id = Pl.Pl_Id
3258: and P_Effective_Date
3259: Between Plip.Effective_Start_Date
3260: and Nvl(Plip.Effective_End_Date,hr_general.end_of_time)

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

3256: and Nvl(Pl.Effective_End_Date,hr_general.end_of_time)
3257: and Plip.Pl_Id = Pl.Pl_Id
3258: and P_Effective_Date
3259: Between Plip.Effective_Start_Date
3260: and Nvl(Plip.Effective_End_Date,hr_general.end_of_time)
3261: and Plip.Pgm_Id = Pgm.Pgm_Id
3262: and P_Effective_Date
3263: Between Pgm.Effective_Start_Date
3264: and Nvl(Pgm.Effective_End_Date,hr_general.end_of_time)

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

3260: and Nvl(Plip.Effective_End_Date,hr_general.end_of_time)
3261: and Plip.Pgm_Id = Pgm.Pgm_Id
3262: and P_Effective_Date
3263: Between Pgm.Effective_Start_Date
3264: and Nvl(Pgm.Effective_End_Date,hr_general.end_of_time)
3265: and pgm.Business_group_id = p_Business_Group_Id
3266: and (pgm.ACTY_REF_PERD_CD <> l_rate
3267: or pgm.Pgm_Uom <> l_currency)
3268: and Pgm_Typ_Cd = 'GSP'

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

3960: hr_rate_api.create_rate
3961: (p_validate => false
3962: ,p_effective_date => trunc(sysdate)
3963: ,p_business_group_id => p_business_group_id
3964: ,p_name => hr_general.decode_lookup('PQH_GSP_GEN_PAY_RATE_NAME',p_ldr_period_code)
3965: ,p_rate_type => 'G'
3966: ,p_rate_uom => 'M'
3967: ,p_object_version_number => l_ovn
3968: ,p_rate_id => l_rate_id);

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

5081: where table_alias ='PLN'
5082: and result_type_cd = 'DISPLAY'
5083: and gs_mirror_src_entity_result_id = p_copy_entity_result_id)
5084: and table_alias = 'HRRATE' and l_action_dt
5085: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);
5086:
5087: Cursor Csr_Action_Dt is
5088: Select Action_Date
5089: From Pqh_Copy_Entity_txns

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

5103: and information278 = point_cer_id
5104: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5105: and table_alias = 'HRRATE' and l_action_dt
5106:
5107: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);
5108:
5109: l_point_cer_id number := -1;
5110: l_action_date date;
5111: cnt number := 0;

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

5440: where copy_entity_result_id = rec_steps.copy_entity_result_id; */
5441:
5442: Pqh_Gsp_Grd_Step_Remove.REMOVE_OIPL(P_COPY_ENTITY_TXN_ID => p_copy_entity_txn_id
5443: ,P_COPY_ENTITY_RESULT_ID => rec_steps.copy_entity_result_id
5444: ,P_EFFECTIVE_DATE => Nvl(L_Action_Date, hr_general.Effective_Date));
5445:
5446: end loop;
5447:
5448:

Line 5682: return Hr_General.DEFAULT_CURRENCY_CODE(p_Business_group_Id);

5678: --
5679: FUNCTION get_bg_currency(p_business_group_id in number) RETURN varchar2
5680: is
5681: begin
5682: return Hr_General.DEFAULT_CURRENCY_CODE(p_Business_group_Id);
5683: end get_bg_currency;
5684: --
5685: PROCEDURE chk_grd_ldr_details (
5686: p_business_group_id IN NUMBER,