DBA Data[Home] [Help]

APPS.PA_FCST_GLOBAL dependencies on MO_GLOBAL

Line 831: AND ((mo_global.get_current_org_id is NULL AND -- 4874283

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

Line 832: mo_global.check_access(pia.org_id) = 'Y') -- 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:

Line 834: (mo_global.get_current_org_id is NOT NULL AND -- 4874283

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

Line 835: pia.org_id = mo_global.get_current_org_id)); -- 4874283

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;

Line 1238: WHERE ((mo_global.get_current_org_id is NULL AND -- 4874283

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

Line 1239: mo_global.check_access(per.org_id) = 'Y') -- 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;

Line 1241: (mo_global.get_current_org_id is NOT NULL AND -- 4874283

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

Line 1242: per.org_id = mo_global.get_current_org_id)); -- 4874283

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;