eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_FI_VALIDATE_PKG dependencies on FND_SESSIONS

Line 337: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s

333:
334: CURSOR orglocalunit
335: IS
336: SELECT COUNT(*)
337: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
338: WHERE o.organization_id = hoi.organization_id
339: AND hoi.org_information_context = 'CLASS'
340: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
341: AND o.business_group_id = l_business_group_id

Line 345: FROM hr_organization_units org, hr_organization_information hoinf , fnd_sessions s

341: AND o.business_group_id = l_business_group_id
342: AND TO_CHAR(o.organization_id) IN
343: (
344: SELECT hoinf.org_information1
345: FROM hr_organization_units org, hr_organization_information hoinf , fnd_sessions s
346: WHERE org.business_group_id = l_business_group_id
347: AND org.organization_id = hoinf.organization_id
348: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'
349: AND s.session_id = userenv('sessionid')

Line 360: FROM hr_organization_information hoi, hr_organization_units ou ,fnd_sessions s

356:
357: CURSOR getynumber
358: IS
359: SELECT count(*)
360: FROM hr_organization_information hoi, hr_organization_units ou ,fnd_sessions s
361: WHERE (hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
362: hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
363: AND ou.organization_id = hoi.organization_id
364: AND ou.organization_id <> nvl(p_organization_id , 0)

Line 595: select EFFECTIVE_DATE into l_session_date from fnd_sessions where SESSION_ID = userenv('SESSIONID');

591: -- For PIN --
592: IF p_org_information2 IS NOT NULL
593: THEN
594: BEGIN
595: select EFFECTIVE_DATE into l_session_date from fnd_sessions where SESSION_ID = userenv('SESSIONID');
596: l_return := hr_ni_chk_pkg.validate_national_identifier(p_org_information2,null,null,'WHEN-VALIDATE-RECORD',null,l_business_group_id,'FI',l_session_date,l_warning,null,null,null);
597: EXCEPTION
598: WHEN OTHERS
599: THEN

Line 1149: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s

1145:
1146: CURSOR orglocalunit
1147: IS
1148: SELECT COUNT(*)
1149: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
1150: WHERE o.organization_id = hoi.organization_id
1151: AND hoi.org_information_context = 'CLASS'
1152: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
1153: AND o.business_group_id = l_business_group_id

Line 1157: FROM hr_organization_units org, hr_organization_information hoinf ,fnd_sessions s

1153: AND o.business_group_id = l_business_group_id
1154: AND TO_CHAR(o.organization_id) IN
1155: (
1156: SELECT hoinf.org_information1
1157: FROM hr_organization_units org, hr_organization_information hoinf ,fnd_sessions s
1158: WHERE org.business_group_id = l_business_group_id
1159: AND org.organization_id = hoinf.organization_id
1160: AND org.organization_id <> l_organization_id
1161: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'

Line 1426: SELECT EFFECTIVE_DATE INTO l_session_date FROM fnd_sessions WHERE SESSION_ID = userenv('SESSIONID');

1422:
1423: IF p_org_information2 IS NOT NULL
1424: THEN
1425: BEGIN
1426: SELECT EFFECTIVE_DATE INTO l_session_date FROM fnd_sessions WHERE SESSION_ID = userenv('SESSIONID');
1427: l_return :=hr_ni_chk_pkg.validate_national_identifier(p_org_information2,null,null,'WHEN-VALIDATE-RECORD',null,l_business_group_id,'FI',l_session_date,l_warning,null,null,null);
1428: EXCEPTION
1429: WHEN OTHERS
1430: THEN