APPS.PAY_JP_GET_MONTH_BALANCE_PKG dependencies on FND_SESSIONS

Line 38: from fnd_sessions

34: add_months(last_day(effective_date), (-1 + (-1 * abs(p_months_prior)))) + 1
35: into l_effective_date,
36: l_end_month_date,
37: l_start_month_date
38: from fnd_sessions
39: where session_id = userenv('sessionid');
40:
41: BEGIN
42: SELECT NVL(SUM(TARGET.result_value * FEED.scale),0)

Line 103: from fnd_sessions

99: add_months(last_day(effective_date), (-1 + (-1 * abs(p_months_prior)))) + 1
100: into l_effective_date,
101: l_end_month_date,
102: l_start_month_date
103: from fnd_sessions
104: where session_id = userenv('sessionid');
105:
106: BEGIN
107: SELECT NVL(SUM(TARGET.result_value * FEED.scale),0)