APPS.PAY_SA_GOSI_REPORTS dependencies on FND_SESSIONS

Line 477: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),to_date(l_effective_date,'DD-MM-YYYY'));

473: l_last_prev_month_date1 := (last_day(to_date(l_test_prev_month_date,'DD-MM-YYYY')));
474: l_last_prev_month_date := to_char(l_last_prev_month_date1,'DD-MM-YYYY');
475: --l_last_prev_month_date := '27-12-1999';
476:
477: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),to_date(l_effective_date,'DD-MM-YYYY'));
478:
479: /*Commented the hierarchy part on 15-Jan-2004 */
480: /*if p_org_structure_version_id is not null then
481: open csr_org_hierarchy;

Line 744: FROM HR_LOOKUPS H, FND_SESSIONS S

740: vXMLTable(vCtr).TagValue := null;
741: else
742: begin
743: SELECT meaning INTO l_nationality_mn
744: FROM HR_LOOKUPS H, FND_SESSIONS S
745: WHERE LOOKUP_TYPE = 'NATIONALITY'
746: AND ENABLED_FLAG = 'Y'
747: AND LOOKUP_CODE = l_nationality
748: AND SESSION_ID = USERENV('SESSIONID')

Line 975: FROM HR_LOOKUPS H, FND_SESSIONS S

971: between nvl(hl.start_date_active,to_date( and hl.end_date_active
972: AND hl.lookup_code = l_term_reason;*/
973: BEGIN
974: SELECT meaning INTO l_term_reason_mn
975: FROM HR_LOOKUPS H, FND_SESSIONS S
976: WHERE LOOKUP_TYPE = 'LEAV_REAS'
977: AND ENABLED_FLAG = 'Y'
978: AND LOOKUP_CODE = l_term_reason
979: AND SESSION_ID = USERENV('SESSIONID')

Line 1363: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),l_effective_date);

1359: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
1360: /*Following 1 line changed for enhancement 5283457
1361: l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
1362: l_eff_term_date := l_effective_date;
1363: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),l_effective_date);
1364: -- To clear the PL/SQL Table values.
1365: vXMLTable.DELETE;
1366: vCtr := 1;
1367: hr_utility.set_location('Before hierarchy logic ',40);

Line 2936: insert into fnd_sessions(session_id,effective_date) values (userenv('sessionid'), l_effective_date);

2932: vXMLTable.DELETE;
2933: vCtr := 1;
2934: --l_effective_date := last_day(fnd_date.canonical_to_date(p_effective_date));
2935: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
2936: insert into fnd_sessions(session_id,effective_date) values (userenv('sessionid'), l_effective_date);
2937: for m in t_form_type.first .. t_form_type.last
2938: loop
2939: l_form := t_form_type(m);
2940: T_EMP.DELETE;