APPS.HR_SE_VALIDATE_PKG dependencies on FND_SESSIONS

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

221: WHERE organization_id = p_organization_id;
222: /*
223: CURSOR orglocalunit IS
224: select o.organization_id
225: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
226: where o.organization_id = hoi.organization_id
227: and hoi.org_information_context = 'CLASS'
228: and hoi.org_information1 = 'SE_LOCAL_UNIT'
229: and to_char(o.organization_id) in

Line 246: FND_SESSIONS s

242: select o.organization_id
243: from hr_organization_units o ,
244: hr_organization_information hoi,
245: hr_organization_information hoinf,
246: FND_SESSIONS s
247: where o.organization_id = hoi.organization_id
248: and o.business_group_id = l_business_group_id
249: and hoi.org_information_context = 'CLASS'
250: and hoi.org_information1 = 'SE_LOCAL_UNIT'

Line 605: FND_SESSIONS s

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

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

622: l_agreement_meaning varchar2(50);
623:
624: CURSOR csr_year IS
625: SELECT count(*)
626: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
627: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
628: AND ou.organization_id = hoi.organization_id
629: AND ou.organization_id = nvl (p_organization_id, 0)
630: AND ou.business_group_id = l_business_group_id

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

1076:
1077: /*
1078: CURSOR orglocalunit IS
1079: SELECT o.organization_id
1080: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
1081: WHERE o.organization_id = hoi.organization_id
1082: AND hoi.org_information_context = 'CLASS'
1083: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1084: AND to_char(o.organization_id) IN

Line 1102: FND_SESSIONS s

1098: CURSOR orglocalunit IS select o.organization_id
1099: from hr_organization_units o ,
1100: hr_organization_information hoi,
1101: hr_organization_information hoinf,
1102: FND_SESSIONS s
1103: where o.organization_id = hoi.organization_id
1104: and o.business_group_id = l_business_group_id
1105: and hoi.org_information_context = 'CLASS'
1106: and hoi.org_information1 = 'SE_LOCAL_UNIT'

Line 1478: FND_SESSIONS s

1474: WHERE org_information_id=p_org_information_id;
1475:
1476: CURSOR csr_global(csr_v_global VARCHAR2 )IS
1477: SELECT nvl(global_value,0) FROM ff_globals_f,
1478: FND_SESSIONS s
1479: WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
1480: AND legislation_code='SE'
1481: and s.effective_date --p_effective_date
1482: BETWEEN effective_start_date AND

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

1494: l_agreement_meaning varchar2(50);
1495:
1496: CURSOR csr_year IS
1497: SELECT count(*)
1498: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
1499: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
1500: AND ou.organization_id = hoi.organization_id
1501: AND ou.organization_id = nvl (l_organization_id, 0)
1502: AND ou.business_group_id = l_business_group_id