APPS.HRI_PARAMETERS dependencies on HR_GENERAL

Line 36: where business_group_id = Hr_General.Get_Business_Group_Id;

32:
33: cursor c_job_lov_check is
34: select count(*)+1
35: from per_jobs -- bug fix 3680782
36: where business_group_id = Hr_General.Get_Business_Group_Id;
37:
38:
39: BEGIN
40:

Line 1190: and sysdate between nvl(c.start_date_active, hr_general.start_of_time)

1186: select c.currency_code , c.name
1187: from per_business_groups b , fnd_currencies_vl c
1188: where b.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1189: and c.enabled_flag = 'Y'
1190: and sysdate between nvl(c.start_date_active, hr_general.start_of_time)
1191: and nvl(c.end_date_active, hr_general.end_of_time)
1192: order by decode(b.currency_code, c.currency_code, 1,2) , c.currency_code;
1193:
1194: BEGIN

Line 1191: and nvl(c.end_date_active, hr_general.end_of_time)

1187: from per_business_groups b , fnd_currencies_vl c
1188: where b.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1189: and c.enabled_flag = 'Y'
1190: and sysdate between nvl(c.start_date_active, hr_general.start_of_time)
1191: and nvl(c.end_date_active, hr_general.end_of_time)
1192: order by decode(b.currency_code, c.currency_code, 1,2) , c.currency_code;
1193:
1194: BEGIN
1195:

Line 1806: where business_group_id = Hr_General.Get_Business_Group_Id

1802:
1803: cursor c_job_list is
1804: select job_id, name job_name
1805: from per_jobs -- bug fix 3680782
1806: where business_group_id = Hr_General.Get_Business_Group_Id
1807: order by name; -- use of p_option = 1
1808:
1809: l_job_id_count number :=0;
1810: