938: l_user_id NUMBER;
939: BEGIN
940:
941: l_security_profile_id := fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
942: l_user_id := fnd_global.user_id;
943:
944: SELECT organization_id,
945: view_all_organizations_flag ,
946: include_top_organization_flag
1007:
1008: BEGIN
1009: --Important: Any change in logic made here should be updated in the function PJI_ORGANIZATION_EXISTS also
1010: --Bug 4599990.
1011: l_user_id := fnd_global.user_id;
1012:
1013: get_top_org_details(
1014: x_top_org_id => l_top_organization_id,
1015: x_top_org_name => l_top_org_name,