DBA Data[Home] [Help]

APPS.PAY_GB_EPS_13 dependencies on FND_SESSIONS

Line 572: --select effective_date into system_date from fnd_sessions where session_id = userenv('SESSIONID');

568:
569: hr_utility.set_location(' p_object_version_number :' || p_object_version_number,160);
570: hr_utility.set_location(' l_object_version_number :' || l_object_version_number,160);
571:
572: --select effective_date into system_date from fnd_sessions where session_id = userenv('SESSIONID');
573: if (p_object_version_number <> l_object_version_number) then
574: --p_return_status := 'E';
575: p_return_status := 'E';
576: raise l_exp;

Line 1549: select effective_date into system_date from fnd_sessions where session_id = userenv('SESSIONID');

1545: is
1546: tax_year number;
1547: system_date date;
1548: begin
1549: select effective_date into system_date from fnd_sessions where session_id = userenv('SESSIONID');
1550: if( to_char(system_date,'mmdd')>='0406' ) then
1551: tax_year := to_number(to_char(system_date,'YYYY')) ;
1552: ELSE tax_year := to_number(to_char(system_date,'YYYY'))- 1;
1553: end if;