APPS.PAY_KW_ANNUAL_REPORTS dependencies on FND_SESSIONS

Line 279: INSERT INTO fnd_sessions (session_id, effective_date)

275:
276: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
277: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
278:
279: INSERT INTO fnd_sessions (session_id, effective_date)
280: VALUES (userenv('sessionid'), l_effective_date);
281:
282: -- To clear the PL/SQL Table values.
283: vXMLTable.DELETE;

Line 857: INSERT INTO fnd_sessions (session_id, effective_date)

853:
854: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
855: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
856: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
857: INSERT INTO fnd_sessions (session_id, effective_date)
858: VALUES (userenv('sessionid'), l_effective_date);
859:
860: -- To clear the PL/SQL Table values.
861: vXMLTable.DELETE;

Line 1677: INSERT INTO fnd_sessions (session_id, effective_date)

1673:
1674: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
1675: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
1676: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
1677: INSERT INTO fnd_sessions (session_id, effective_date)
1678: VALUES (userenv('sessionid'), l_effective_date);
1679:
1680: -- To clear the PL/SQL Table values.
1681: vXMLTable.DELETE;