APPS.PQP_GB_AD_EE dependencies on FND_SESSIONS

Line 2132: select count(*) into l_session_present from fnd_sessions ses

2128: hr_utility.set_location('PAYE l_tax_code :'||l_tax_code ,18);
2129: --10157179 Begin
2130: /*SESSION Date should be present for the view pay_paye_element_entries_v
2131: used in cursor cur_element_entry_id. */
2132: select count(*) into l_session_present from fnd_sessions ses
2133: where ses.session_id = userenv('SESSIONID');
2134: If l_session_present <> 1 then
2135: hr_utility.set_location('No session date so inserting ',18);
2136: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)

Line 2136: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)

2132: select count(*) into l_session_present from fnd_sessions ses
2133: where ses.session_id = userenv('SESSIONID');
2134: If l_session_present <> 1 then
2135: hr_utility.set_location('No session date so inserting ',18);
2136: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
2137: values(userenv('sessionid'), p_effective_date);
2138: End if;
2139:
2140: --OPEN cur_element_entry_id(l_paye_assg_id,l_paye_ini_tax_dist);