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 342: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s

338:
339: CURSOR orglocalunit
340: IS
341: SELECT COUNT(*)
342: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
343: WHERE o.organization_id = hoi.organization_id
344: AND hoi.org_information_context = 'CLASS'
345: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
346: AND o.business_group_id = l_business_group_id

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

346: AND o.business_group_id = l_business_group_id
347: AND TO_CHAR(o.organization_id) IN
348: (
349: SELECT hoinf.org_information1
350: FROM hr_organization_units org, hr_organization_information hoinf , fnd_sessions s
351: WHERE org.business_group_id = l_business_group_id
352: AND org.organization_id = hoinf.organization_id
353: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'
354: AND s.session_id = userenv('sessionid')

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

361:
362: CURSOR getynumber
363: IS
364: SELECT count(*)
365: FROM hr_organization_information hoi, hr_organization_units ou ,fnd_sessions s
366: WHERE (hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
367: hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
368: AND ou.organization_id = hoi.organization_id
369: AND ou.organization_id <> nvl(p_organization_id , 0)

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

596: -- For PIN --
597: IF p_org_information2 IS NOT NULL
598: THEN
599: BEGIN
600: select EFFECTIVE_DATE into l_session_date from fnd_sessions where SESSION_ID = userenv('SESSIONID');
601: 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);
602: EXCEPTION
603: WHEN OTHERS
604: THEN

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

1159:
1160: CURSOR orglocalunit
1161: IS
1162: SELECT COUNT(*)
1163: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
1164: WHERE o.organization_id = hoi.organization_id
1165: AND hoi.org_information_context = 'CLASS'
1166: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
1167: AND o.business_group_id = l_business_group_id

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

1167: AND o.business_group_id = l_business_group_id
1168: AND TO_CHAR(o.organization_id) IN
1169: (
1170: SELECT hoinf.org_information1
1171: FROM hr_organization_units org, hr_organization_information hoinf ,fnd_sessions s
1172: WHERE org.business_group_id = l_business_group_id
1173: AND org.organization_id = hoinf.organization_id
1174: AND org.organization_id <> l_organization_id
1175: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'

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

1436:
1437: IF p_org_information2 IS NOT NULL
1438: THEN
1439: BEGIN
1440: SELECT EFFECTIVE_DATE INTO l_session_date FROM fnd_sessions WHERE SESSION_ID = userenv('SESSIONID');
1441: 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);
1442: EXCEPTION
1443: WHEN OTHERS
1444: THEN