APPS.PAY_KW_ANNUAL_REPORTS dependencies on FND_SESSIONS

Line 298: INSERT INTO fnd_sessions (session_id, effective_date)

294:
295: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
296: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
297:
298: INSERT INTO fnd_sessions (session_id, effective_date)
299: VALUES (userenv('sessionid'), l_effective_date);
300:
301: -- To clear the PL/SQL Table values.
302: vXMLTable.DELETE;

Line 915: INSERT INTO fnd_sessions (session_id, effective_date)

911:
912: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
913: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
914: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
915: INSERT INTO fnd_sessions (session_id, effective_date)
916: VALUES (userenv('sessionid'), l_effective_date);
917:
918: -- To clear the PL/SQL Table values.
919: vXMLTable.DELETE;

Line 1758: INSERT INTO fnd_sessions (session_id, effective_date)

1754:
1755: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
1756: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
1757: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
1758: INSERT INTO fnd_sessions (session_id, effective_date)
1759: VALUES (userenv('sessionid'), l_effective_date);
1760:
1761: -- To clear the PL/SQL Table values.
1762: vXMLTable.DELETE;