827: SELECT sob.period_set_name
828: FROM gl_sets_of_books sob,
829: pa_implementations_all pia
830: WHERE pia.set_of_books_id = sob.set_of_books_id
831: AND ((mo_global.get_current_org_id is NULL AND -- 4874283
832: mo_global.check_access(pia.org_id) = 'Y') -- 4874283
833: OR -- 4874283
834: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
835: pia.org_id = mo_global.get_current_org_id)); -- 4874283
828: FROM gl_sets_of_books sob,
829: pa_implementations_all pia
830: WHERE pia.set_of_books_id = sob.set_of_books_id
831: AND ((mo_global.get_current_org_id is NULL AND -- 4874283
832: mo_global.check_access(pia.org_id) = 'Y') -- 4874283
833: OR -- 4874283
834: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
835: pia.org_id = mo_global.get_current_org_id)); -- 4874283
836:
830: WHERE pia.set_of_books_id = sob.set_of_books_id
831: AND ((mo_global.get_current_org_id is NULL AND -- 4874283
832: mo_global.check_access(pia.org_id) = 'Y') -- 4874283
833: OR -- 4874283
834: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
835: pia.org_id = mo_global.get_current_org_id)); -- 4874283
836:
837:
838: BEGIN
831: AND ((mo_global.get_current_org_id is NULL AND -- 4874283
832: mo_global.check_access(pia.org_id) = 'Y') -- 4874283
833: OR -- 4874283
834: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
835: pia.org_id = mo_global.get_current_org_id)); -- 4874283
836:
837:
838: BEGIN
839: OPEN cur_period_set_name;
1234: SELECT PER.PERIOD_NAME,
1235: PER.START_DATE,
1236: PER.END_DATE
1237: FROM PA_PERIODS_ALL PER
1238: WHERE ((mo_global.get_current_org_id is NULL AND -- 4874283
1239: mo_global.check_access(per.org_id) = 'Y') -- 4874283
1240: OR -- 4874283
1241: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
1242: per.org_id = mo_global.get_current_org_id)); -- 4874283
1235: PER.START_DATE,
1236: PER.END_DATE
1237: FROM PA_PERIODS_ALL PER
1238: WHERE ((mo_global.get_current_org_id is NULL AND -- 4874283
1239: mo_global.check_access(per.org_id) = 'Y') -- 4874283
1240: OR -- 4874283
1241: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
1242: per.org_id = mo_global.get_current_org_id)); -- 4874283
1243: END IF;
1237: FROM PA_PERIODS_ALL PER
1238: WHERE ((mo_global.get_current_org_id is NULL AND -- 4874283
1239: mo_global.check_access(per.org_id) = 'Y') -- 4874283
1240: OR -- 4874283
1241: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
1242: per.org_id = mo_global.get_current_org_id)); -- 4874283
1243: END IF;
1244: END Populate_Fcst_Periods;
1245: BEGIN
1238: WHERE ((mo_global.get_current_org_id is NULL AND -- 4874283
1239: mo_global.check_access(per.org_id) = 'Y') -- 4874283
1240: OR -- 4874283
1241: (mo_global.get_current_org_id is NOT NULL AND -- 4874283
1242: per.org_id = mo_global.get_current_org_id)); -- 4874283
1243: END IF;
1244: END Populate_Fcst_Periods;
1245: BEGIN
1246: Global_CrossProjectViewUser := SetCrossProjectViewUser;