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 1623: p_effective_date) from dual);

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

Line 1661: p_effective_date) from dual);

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

Line 1700: p_effective_date) from dual);

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