eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_UTILS dependencies on PA_IMPLEMENTATIONS

Line 478: pa_implementations_all iprv,

474: FROM HR_ORGANIZATION_INFORMATION PLE,
475: HR_ORGANIZATION_INFORMATION RLE,
476: pa_project_types_all PT,
477: pa_projects_all P,
478: pa_implementations_all iprv,
479: pa_implementations_all irecv
480: WHERE P.project_type = PT.project_type
481: AND NVL(P.template_flag, 'N') <> 'Y'
482: --Bug2538692 AND pa_security.allow_query(P.project_id) = 'Y'

Line 479: pa_implementations_all irecv

475: HR_ORGANIZATION_INFORMATION RLE,
476: pa_project_types_all PT,
477: pa_projects_all P,
478: pa_implementations_all iprv,
479: pa_implementations_all irecv
480: WHERE P.project_type = PT.project_type
481: AND NVL(P.template_flag, 'N') <> 'Y'
482: --Bug2538692 AND pa_security.allow_query(P.project_id) = 'Y'
483: AND ((iprv.business_group_id = irecv.business_group_id

Line 2157: pa_implementations imp

2153: --MOAC Changes : Bug 4363092: Get the value of org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
2154: /* CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2155: select org.child_organization_id c_org
2156: from pa_org_hierarchy_denorm org,
2157: pa_implementations imp
2158: where org.parent_organization_id = p_org_id
2159: and org.parent_level - org.child_level = 1
2160: and org.pa_org_use_type = 'REPORTING'
2161: and org.org_hierarchy_version_id = imp.org_structure_version_id

Line 2169: pa_implementations imp

2165: order by org.child_organization_id; */
2166: CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2167: select org.child_organization_id c_org
2168: from pa_org_hierarchy_denorm org,
2169: pa_implementations imp
2170: where org.parent_organization_id = p_org_id
2171: and org.parent_level - org.child_level = 1
2172: and org.pa_org_use_type = 'REPORTING'
2173: and org.org_hierarchy_version_id = imp.org_structure_version_id

Line 2192: pa_implementations pai

2188:
2189: select glp.end_date into l_date
2190: from gl_periods glp,
2191: gl_sets_of_books glsob,
2192: pa_implementations pai
2193: where pai.set_of_books_id = glsob.set_of_books_id
2194: and glsob.period_set_name = glp.period_set_name
2195: and glsob.accounted_period_type = glp.period_type
2196: and glp.period_name = p_period_name;

Line 2202: pa_implementations pai

2198: ELSIF (p_period_type = 'PA') THEN
2199: /* code commented for Bug 2634995
2200: select pap.pa_end_date into l_date
2201: from pa_periods_v pap,
2202: pa_implementations pai
2203: where pap.period_name = p_period_name
2204: and pai.set_of_books_id = pap.set_of_books_id;
2205: */
2206:

Line 2213: PA_IMPLEMENTATIONS PAIMP,

2209: SELECT pap.end_date
2210: INTO l_date
2211: FROM PA_PERIODS PAP,
2212: GL_PERIOD_STATUSES GLP,
2213: PA_IMPLEMENTATIONS PAIMP,
2214: PA_LOOKUPS PAL
2215: WHERE PAP.period_name = p_period_name
2216: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2217: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID

Line 2230: pa_implementations pai

2226: select max(glp.end_date)
2227: into l_date
2228: from gl_periods glp,
2229: gl_sets_of_books glsob,
2230: pa_implementations pai
2231: where pai.set_of_books_id = glsob.set_of_books_id
2232: and glsob.period_set_name = glp.period_set_name
2233: and glsob.accounted_period_type = glp.period_type
2234: and glp.period_year = p_year;

Line 2242: pa_implementations pai

2238: select max(glp.end_date)
2239: into l_date
2240: from gl_periods glp,
2241: gl_sets_of_books glsob,
2242: pa_implementations pai
2243: where pai.set_of_books_id = glsob.set_of_books_id
2244: and glsob.period_set_name = glp.period_set_name
2245: and glsob.accounted_period_type = glp.period_type
2246: and glp.quarter_num = to_number(p_period_name)

Line 2349: pa_implementations pai

2345:
2346: select glp.start_date into l_date
2347: from gl_periods glp,
2348: gl_sets_of_books glsob,
2349: pa_implementations pai
2350: where pai.set_of_books_id = glsob.set_of_books_id
2351: and glsob.period_set_name = glp.period_set_name
2352: and glsob.accounted_period_type = glp.period_type
2353: and glp.period_name = p_period_name;

Line 2360: pa_implementations pai

2356:
2357: /* code commented for Bug 2634995
2358: select pap.pa_start_date into l_date
2359: from pa_periods_v pap,
2360: pa_implementations pai
2361: where pap.period_name = p_period_name
2362: and pai.set_of_books_id = pap.set_of_books_id;
2363: */
2364:

Line 2372: PA_IMPLEMENTATIONS PAIMP,

2368: SELECT pap.start_date
2369: INTO l_date
2370: FROM PA_PERIODS PAP,
2371: GL_PERIOD_STATUSES GLP,
2372: PA_IMPLEMENTATIONS PAIMP,
2373: PA_LOOKUPS PAL
2374: WHERE PAP.period_name = p_period_name
2375: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2376: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID

Line 2387: pa_implementations pai

2383: select min(glp.start_date)
2384: into l_date
2385: from gl_periods glp,
2386: gl_sets_of_books glsob,
2387: pa_implementations pai
2388: where pai.set_of_books_id = glsob.set_of_books_id
2389: and glsob.period_set_name = glp.period_set_name
2390: and glsob.accounted_period_type = glp.period_type
2391: and glp.period_year = p_year;

Line 2399: pa_implementations pai

2395: select min(glp.start_date)
2396: into l_date
2397: from gl_periods glp,
2398: gl_sets_of_books glsob,
2399: pa_implementations pai
2400: where pai.set_of_books_id = glsob.set_of_books_id
2401: and glsob.period_set_name = glp.period_set_name
2402: and glsob.accounted_period_type = glp.period_type
2403: and glp.quarter_num = to_number(p_period_name)

Line 2775: -- 04-DEC-2002 sacgupta Bug#2673140.Table pa_implementations is included to check Expenditure organization.

2771: --
2772: -- HISTORY
2773: -- 10-MAY-2001 created virangan
2774: --
2775: -- 04-DEC-2002 sacgupta Bug#2673140.Table pa_implementations is included to check Expenditure organization.
2776: -- 28-MAR-2003 sacgupta Bug#2876296. Reverted the fix done for bug#2673140.
2777: -- The fix for the bug#2673140 has resulted in other
2778: -- issues related to resource pull.
2779: PROCEDURE Check_Exp_Org (p_organization_id IN NUMBER,

Line 2798: pa_implementations i -- Added for bug 2673140

2794: /*
2795: SELECT 'Y'
2796: INTO x_valid
2797: FROM pa_all_organizations o,
2798: pa_implementations i -- Added for bug 2673140
2799: WHERE o.pa_org_use_type = 'EXPENDITURES'
2800: AND o.inactive_date is null
2801: AND o.organization_id = p_organization_id
2802: AND rownum = 1