APPS.GHR_FORMULA_FUNCTIONS dependencies on DUAL

Line 351: where session_id = (select userenv('sessionid') from dual);

347: l_session_date fnd_sessions.effective_date%type;
348: cursor c_get_session_date is
349: select trunc(effective_date) session_date
350: from fnd_sessions
351: where session_id = (select userenv('sessionid') from dual);
352: cursor c_per_id is
353: select person_id from
354: per_assignments_f
355: where assignment_id = p_assignment_id

Line 1627: p_effective_date) from dual);

1623: from ghr_people_extra_info_h_v
1624: where pa_history_id =
1625: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,
1626: 'GHR_US_PER_BENEFIT_INFO',
1627: p_effective_date) from dual);
1628: Begin
1629: l_proc_name := g_package || '.get_agency_contrib_date';
1630: hr_utility.set_location('Entering ' ||l_proc_name,10);
1631: for get_person_id in c_get_person_id loop

Line 1665: p_effective_date) from dual);

1661: from ghr_people_extra_info_h_v
1662: where pa_history_id =
1663: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,
1664: 'GHR_US_PER_BENEFIT_INFO',
1665: p_effective_date) from dual);
1666: Begin
1667: l_proc_name := g_package || 'get_emp_contrib_date';
1668: hr_utility.set_location('Entering ' ||l_proc_name,10);
1669: for get_person_id in c_get_person_id loop

Line 1704: p_effective_date) from dual);

1700: from ghr_people_extra_info_h_v
1701: where pa_history_id =
1702: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,
1703: 'GHR_US_PER_BENEFIT_INFO',
1704: p_effective_date) from dual);
1705: Begin
1706: l_proc_name := g_package || 'get_coe_date';
1707: hr_utility.set_location('Entering ' ||l_proc_name,10);
1708: for get_person_id in c_get_person_id loop

Line 2282: where session_id = (select userenv('sessionid') from dual);

2278:
2279: cursor c_get_eff_st_dt is
2280: select trunc(effective_date) session_date
2281: from fnd_sessions
2282: where session_id = (select userenv('sessionid') from dual);
2283:
2284:
2285: -- get hire date
2286: Cursor c_get_hire_date is