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_INTEGRATION dependencies on PA_PERIODS_ALL

Line 248: FROM pa_periods_all pap1

244: ,pap1.period_name
245: INTO l_earliest_start_date
246: ,l_earliest_end_date
247: ,l_earliest_period_name
248: FROM pa_periods_all pap1
249: WHERE pap1.status IN ('O','F')
250: AND pap1.org_id = p_org_id
251: AND pap1.start_date = ( SELECT MIN(pap.start_date)
252: FROM pa_periods_all pap

Line 252: FROM pa_periods_all pap

248: FROM pa_periods_all pap1
249: WHERE pap1.status IN ('O','F')
250: AND pap1.org_id = p_org_id
251: AND pap1.start_date = ( SELECT MIN(pap.start_date)
252: FROM pa_periods_all pap
253: WHERE status IN ('O','F')
254: AND org_id = p_org_id
255: );
256: END IF ;

Line 276: FROM pa_periods_all pap

272: INTO l_start_date
273: ,l_end_date
274: ,l_pa_date
275: ,l_period_name
276: FROM pa_periods_all pap
277: WHERE pap.status in ('O','F')
278: AND pap.end_date >= TRUNC(p_expenditure_item_date)
279: AND p_accounting_date BETWEEN pap.start_date and pap.end_date
280: AND org_id = p_org_id ;

Line 290: *This SQL will FAIL - if there are more than one row in pa_periods_all - with the same end_date.

286: END; /* Added for Bug 1657231 */
287:
288: /*If the l_pa_date obtained is NULL, try to find a pa_date without the accounting-date
289: *check. This approach was used even previously.
290: *This SQL will FAIL - if there are more than one row in pa_periods_all - with the same end_date.
291: */
292:
293: IF ( l_pa_date IS NULL )
294: THEN

Line 303: FROM pa_periods_all pap1

299: INTO l_start_date
300: ,l_end_date
301: ,l_pa_date
302: ,l_period_name
303: FROM pa_periods_all pap1
304: WHERE pap1.org_id = p_org_id /*Added While fixing bug 1657231*/
305: AND pap1.start_date = ( SELECT MIN(pap.start_date)
306: FROM pa_periods_all pap
307: WHERE status IN ('O','F')

Line 306: FROM pa_periods_all pap

302: ,l_period_name
303: FROM pa_periods_all pap1
304: WHERE pap1.org_id = p_org_id /*Added While fixing bug 1657231*/
305: AND pap1.start_date = ( SELECT MIN(pap.start_date)
306: FROM pa_periods_all pap
307: WHERE status IN ('O','F')
308: AND pap.start_date >= TRUNC(p_expenditure_item_date)
309: AND org_id = p_org_id
310: );

Line 331: FROM pa_periods_all pap1

327: ,pap1.period_name
328: INTO l_earliest_start_date
329: ,l_earliest_end_date
330: ,l_earliest_period_name
331: FROM pa_periods_all pap1
332: WHERE pap1.status IN ('O', 'F')
333: AND pap1.org_id = p_org_id
334: AND pap1.end_date = ( SELECT MIN(pap.end_date)
335: FROM pa_periods_all pap

Line 335: FROM pa_periods_all pap

331: FROM pa_periods_all pap1
332: WHERE pap1.status IN ('O', 'F')
333: AND pap1.org_id = p_org_id
334: AND pap1.end_date = ( SELECT MIN(pap.end_date)
335: FROM pa_periods_all pap
336: WHERE pap.status IN ('O','F')
337: -- AND p_accounting_date BETWEEN pap.start_date AND pap.end_date /* commented for bug 1982225 */
338: AND pap.org_id = p_org_id
339: );

Line 355: FROM pa_periods_all pap

351: INTO l_start_date
352: ,l_end_date
353: ,l_pa_date
354: ,l_period_name
355: FROM pa_periods_all pap
356: WHERE status in ('O','F')
357: AND pap.end_date >= TRUNC(p_expenditure_item_date)
358: AND p_accounting_date BETWEEN pap.start_date and pap.end_date
359: AND org_id = p_org_id ;

Line 369: *This SQL will FAIL - if there are more than one row in pa_periods_all - with the same end_date.

365: END; /* Added for Bug 1657231 */
366:
367: /*If the l_pa_date obtained is NULL, try to find a pa_date without the accounting-date
368: *check. This approach was used even previously.
369: *This SQL will FAIL - if there are more than one row in pa_periods_all - with the same end_date.
370: */
371:
372: IF ( l_pa_date IS NULL )
373: THEN

Line 382: FROM pa_periods_all pap1

378: INTO l_start_date
379: ,l_end_date
380: ,l_pa_date
381: ,l_period_name
382: FROM pa_periods_all pap1
383: WHERE pap1.end_date = ( SELECT MIN(pap.end_date)
384: FROM pa_periods_all pap
385: WHERE pap.status IN ('O','F')
386: AND pap.end_date >= TRUNC(p_expenditure_item_date)

Line 384: FROM pa_periods_all pap

380: ,l_pa_date
381: ,l_period_name
382: FROM pa_periods_all pap1
383: WHERE pap1.end_date = ( SELECT MIN(pap.end_date)
384: FROM pa_periods_all pap
385: WHERE pap.status IN ('O','F')
386: AND pap.end_date >= TRUNC(p_expenditure_item_date)
387: AND pap.org_id = p_org_id
388: )