APPS.PAY_NZ_EDF dependencies on FND_SESSIONS

Line 254: l_session_date fnd_sessions.effective_date%TYPE; /* Bug 9612150 */

250: l_prd_end_date_fmt VARCHAR2(20);
251: l_payroll_action_id number;
252: l_bg_name per_business_groups.name%TYPE;
253: l_bus_group_id per_business_groups.business_group_id%TYPE;
254: l_session_date fnd_sessions.effective_date%TYPE; /* Bug 9612150 */
255:
256: CURSOR get_parameters(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
257: IS
258: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

Line 285: FROM fnd_sessions

281: * EDF E-FIle process is null,then sesssion date is used. */
282: CURSOR get_session_date
283: IS
284: SELECT TRUNC(effective_date)
285: FROM fnd_sessions
286: WHERE session_id = userenv('SESSIONID');
287:
288: /* 9666103 - Removed per_time_periods join and added pact join to fetch the
289: employees processed based on pact.effective_date */