APPS.PA_RESOURCE_UTILS dependencies on PA_PERIODS

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

2136: -- 2. DIRECT_EMP - Includes all the direct reports
2137: -- 3. TOTAL_EMP - Includes all subordinates
2138: -- p_period_type: Possible values are GL - gl period, GE - global expenditure
2139: -- week, PA - pa period, QR - quarter, YR - year
2140: -- p_period_name: Values only for GL and PA periods, Quarter number for QR
2141: -- p_end_date: Only for global expenditure week GE
2142: -- p_year : For YR and QR types - pass the year
2143: -- Changes for Performance enhancement of Organization Utilization page
2144: -- For GL, PA, QR and YR period types the where clause

Line 2201: from pa_periods_v pap,

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

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

2203: where pap.period_name = p_period_name
2204: and pai.set_of_books_id = pap.set_of_books_id;
2205: */
2206:
2207: /* Select from pa_periods_v is replaced by view definition for Perfomance
2208: Bug 2634995 */
2209: SELECT pap.end_date
2210: INTO l_date
2211: FROM PA_PERIODS PAP,

Line 2211: FROM PA_PERIODS PAP,

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

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

2324: -- QR - quarter
2325: -- YR - year
2326: -- ARGUMENTS
2327: --
2328: -- p_period_name: Values only for GL and PA periods, Quarter
2329: -- number for QR
2330: -- p_end_date: Only for global expenditure week GE
2331: -- p_year : For YR and QR types - pass the year
2332: -------------------------------------------------------------------- */

Line 2359: from pa_periods_v pap,

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

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

2361: where pap.period_name = p_period_name
2362: and pai.set_of_books_id = pap.set_of_books_id;
2363: */
2364:
2365: /* Select from pa_periods_v is replaced by view definition for Perfomance
2366: Bug 2634995 */
2367:
2368: SELECT pap.start_date
2369: INTO l_date

Line 2370: FROM PA_PERIODS PAP,

2366: Bug 2634995 */
2367:
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