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_PERIODS

Line 2023: -- p_period_name: Values only for GL and PA periods, Quarter number for QR

2019: -- 2. DIRECT_EMP - Includes all the direct reports
2020: -- 3. TOTAL_EMP - Includes all subordinates
2021: -- p_period_type: Possible values are GL - gl period, GE - global expenditure
2022: -- week, PA - pa period, QR - quarter, YR - year
2023: -- p_period_name: Values only for GL and PA periods, Quarter number for QR
2024: -- p_end_date: Only for global expenditure week GE
2025: -- p_year : For YR and QR types - pass the year
2026: -- Changes for Performance enhancement of Organization Utilization page
2027: -- For GL, PA, QR and YR period types the where clause

Line 2084: from pa_periods_v pap,

2080:
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: */

Line 2090: /* Select from pa_periods_v is replaced by view definition for Perfomance

2086: where pap.period_name = p_period_name
2087: and pai.set_of_books_id = pap.set_of_books_id;
2088: */
2089:
2090: /* Select from pa_periods_v is replaced by view definition for Perfomance
2091: Bug 2634995 */
2092: SELECT pap.end_date
2093: INTO l_date
2094: FROM PA_PERIODS PAP,

Line 2094: FROM PA_PERIODS PAP,

2090: /* Select from pa_periods_v is replaced by view definition for Perfomance
2091: Bug 2634995 */
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

Line 2211: -- p_period_name: Values only for GL and PA periods, Quarter

2207: -- QR - quarter
2208: -- YR - year
2209: -- ARGUMENTS
2210: --
2211: -- p_period_name: Values only for GL and PA periods, Quarter
2212: -- number for QR
2213: -- p_end_date: Only for global expenditure week GE
2214: -- p_year : For YR and QR types - pass the year
2215: -------------------------------------------------------------------- */

Line 2242: from pa_periods_v pap,

2238: ELSIF (p_period_type = 'PA') THEN
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: */

Line 2248: /* Select from pa_periods_v is replaced by view definition for Perfomance

2244: where pap.period_name = p_period_name
2245: and pai.set_of_books_id = pap.set_of_books_id;
2246: */
2247:
2248: /* Select from pa_periods_v is replaced by view definition for Perfomance
2249: Bug 2634995 */
2250:
2251: SELECT pap.start_date
2252: INTO l_date

Line 2253: FROM PA_PERIODS PAP,

2249: Bug 2634995 */
2250:
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