APPS.HR_SE_VALIDATE_PKG dependencies on FND_SESSIONS

Line 230: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s

226: WHERE organization_id = p_organization_id;
227: /*
228: CURSOR orglocalunit IS
229: select o.organization_id
230: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
231: where o.organization_id = hoi.organization_id
232: and hoi.org_information_context = 'CLASS'
233: and hoi.org_information1 = 'SE_LOCAL_UNIT'
234: and to_char(o.organization_id) in

Line 251: FND_SESSIONS s

247: select o.organization_id
248: from hr_organization_units o ,
249: hr_organization_information hoi,
250: hr_organization_information hoinf,
251: FND_SESSIONS s
252: where o.organization_id = hoi.organization_id
253: and o.business_group_id = l_business_group_id
254: and hoi.org_information_context = 'CLASS'
255: and hoi.org_information1 = 'SE_LOCAL_UNIT'

Line 610: FND_SESSIONS s

606: nvl(fnd_date.canonical_to_date(p_org_information5),to_date('31/12/4712','DD/MM/YYYY'))));
607:
608: CURSOR csr_global(csr_v_global VARCHAR2 )IS
609: SELECT nvl(global_value,0) FROM ff_globals_f,
610: FND_SESSIONS s
611: WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
612: AND legislation_code='SE'
613: and s.effective_date --p_effective_date
614: BETWEEN effective_start_date AND

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

627: l_agreement_meaning varchar2(50);
628:
629: CURSOR csr_year IS
630: SELECT count(*)
631: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
632: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
633: AND ou.organization_id = hoi.organization_id
634: AND ou.organization_id = nvl (p_organization_id, 0)
635: AND ou.business_group_id = l_business_group_id

Line 1085: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s

1081:
1082: /*
1083: CURSOR orglocalunit IS
1084: SELECT o.organization_id
1085: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
1086: WHERE o.organization_id = hoi.organization_id
1087: AND hoi.org_information_context = 'CLASS'
1088: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1089: AND to_char(o.organization_id) IN

Line 1107: FND_SESSIONS s

1103: CURSOR orglocalunit IS select o.organization_id
1104: from hr_organization_units o ,
1105: hr_organization_information hoi,
1106: hr_organization_information hoinf,
1107: FND_SESSIONS s
1108: where o.organization_id = hoi.organization_id
1109: and o.business_group_id = l_business_group_id
1110: and hoi.org_information_context = 'CLASS'
1111: and hoi.org_information1 = 'SE_LOCAL_UNIT'

Line 1483: FND_SESSIONS s

1479: WHERE org_information_id=p_org_information_id;
1480:
1481: CURSOR csr_global(csr_v_global VARCHAR2 )IS
1482: SELECT nvl(global_value,0) FROM ff_globals_f,
1483: FND_SESSIONS s
1484: WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
1485: AND legislation_code='SE'
1486: and s.effective_date --p_effective_date
1487: BETWEEN effective_start_date AND

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

1499: l_agreement_meaning varchar2(50);
1500:
1501: CURSOR csr_year IS
1502: SELECT count(*)
1503: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
1504: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
1505: AND ou.organization_id = hoi.organization_id
1506: AND ou.organization_id = nvl (l_organization_id, 0)
1507: AND ou.business_group_id = l_business_group_id