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 477: pa_implementations_all iprv,

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

Line 478: pa_implementations_all irecv

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

Line 2040: pa_implementations imp

2036: --MOAC Changes : Bug 4363092: Get the value of org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
2037: /* CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2038: select org.child_organization_id c_org
2039: from pa_org_hierarchy_denorm org,
2040: pa_implementations imp
2041: where org.parent_organization_id = p_org_id
2042: and org.parent_level - org.child_level = 1
2043: and org.pa_org_use_type = 'REPORTING'
2044: and org.org_hierarchy_version_id = imp.org_structure_version_id

Line 2052: pa_implementations imp

2048: order by org.child_organization_id; */
2049: CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2050: select org.child_organization_id c_org
2051: from pa_org_hierarchy_denorm org,
2052: pa_implementations imp
2053: where org.parent_organization_id = p_org_id
2054: and org.parent_level - org.child_level = 1
2055: and org.pa_org_use_type = 'REPORTING'
2056: and org.org_hierarchy_version_id = imp.org_structure_version_id

Line 2075: pa_implementations pai

2071:
2072: select glp.end_date into l_date
2073: from gl_periods glp,
2074: gl_sets_of_books glsob,
2075: pa_implementations pai
2076: where pai.set_of_books_id = glsob.set_of_books_id
2077: and glsob.period_set_name = glp.period_set_name
2078: and glsob.accounted_period_type = glp.period_type
2079: and glp.period_name = p_period_name;

Line 2085: pa_implementations pai

2081: ELSIF (p_period_type = 'PA') THEN
2082: /* code commented for Bug 2634995
2083: select pap.pa_end_date into l_date
2084: from pa_periods_v pap,
2085: pa_implementations pai
2086: where pap.period_name = p_period_name
2087: and pai.set_of_books_id = pap.set_of_books_id;
2088: */
2089:

Line 2096: PA_IMPLEMENTATIONS PAIMP,

2092: SELECT pap.end_date
2093: INTO l_date
2094: FROM PA_PERIODS PAP,
2095: GL_PERIOD_STATUSES GLP,
2096: PA_IMPLEMENTATIONS PAIMP,
2097: PA_LOOKUPS PAL
2098: WHERE PAP.period_name = p_period_name
2099: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2100: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID

Line 2113: pa_implementations pai

2109: select max(glp.end_date)
2110: into l_date
2111: from gl_periods glp,
2112: gl_sets_of_books glsob,
2113: pa_implementations pai
2114: where pai.set_of_books_id = glsob.set_of_books_id
2115: and glsob.period_set_name = glp.period_set_name
2116: and glsob.accounted_period_type = glp.period_type
2117: and glp.period_year = p_year;

Line 2125: pa_implementations pai

2121: select max(glp.end_date)
2122: into l_date
2123: from gl_periods glp,
2124: gl_sets_of_books glsob,
2125: pa_implementations pai
2126: where pai.set_of_books_id = glsob.set_of_books_id
2127: and glsob.period_set_name = glp.period_set_name
2128: and glsob.accounted_period_type = glp.period_type
2129: and glp.quarter_num = to_number(p_period_name)

Line 2232: pa_implementations pai

2228:
2229: select glp.start_date into l_date
2230: from gl_periods glp,
2231: gl_sets_of_books glsob,
2232: pa_implementations pai
2233: where pai.set_of_books_id = glsob.set_of_books_id
2234: and glsob.period_set_name = glp.period_set_name
2235: and glsob.accounted_period_type = glp.period_type
2236: and glp.period_name = p_period_name;

Line 2243: pa_implementations pai

2239:
2240: /* code commented for Bug 2634995
2241: select pap.pa_start_date into l_date
2242: from pa_periods_v pap,
2243: pa_implementations pai
2244: where pap.period_name = p_period_name
2245: and pai.set_of_books_id = pap.set_of_books_id;
2246: */
2247:

Line 2255: PA_IMPLEMENTATIONS PAIMP,

2251: SELECT pap.start_date
2252: INTO l_date
2253: FROM PA_PERIODS PAP,
2254: GL_PERIOD_STATUSES GLP,
2255: PA_IMPLEMENTATIONS PAIMP,
2256: PA_LOOKUPS PAL
2257: WHERE PAP.period_name = p_period_name
2258: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2259: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID

Line 2270: pa_implementations pai

2266: select min(glp.start_date)
2267: into l_date
2268: from gl_periods glp,
2269: gl_sets_of_books glsob,
2270: pa_implementations pai
2271: where pai.set_of_books_id = glsob.set_of_books_id
2272: and glsob.period_set_name = glp.period_set_name
2273: and glsob.accounted_period_type = glp.period_type
2274: and glp.period_year = p_year;

Line 2282: pa_implementations pai

2278: select min(glp.start_date)
2279: into l_date
2280: from gl_periods glp,
2281: gl_sets_of_books glsob,
2282: pa_implementations pai
2283: where pai.set_of_books_id = glsob.set_of_books_id
2284: and glsob.period_set_name = glp.period_set_name
2285: and glsob.accounted_period_type = glp.period_type
2286: and glp.quarter_num = to_number(p_period_name)

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

2654: --
2655: -- HISTORY
2656: -- 10-MAY-2001 created virangan
2657: --
2658: -- 04-DEC-2002 sacgupta Bug#2673140.Table pa_implementations is included to check Expenditure organization.
2659: -- 28-MAR-2003 sacgupta Bug#2876296. Reverted the fix done for bug#2673140.
2660: -- The fix for the bug#2673140 has resulted in other
2661: -- issues related to resource pull.
2662: PROCEDURE Check_Exp_Org (p_organization_id IN NUMBER,

Line 2681: pa_implementations i -- Added for bug 2673140

2677: /*
2678: SELECT 'Y'
2679: INTO x_valid
2680: FROM pa_all_organizations o,
2681: pa_implementations i -- Added for bug 2673140
2682: WHERE o.pa_org_use_type = 'EXPENDITURES'
2683: AND o.inactive_date is null
2684: AND o.organization_id = p_organization_id
2685: AND rownum = 1