APPS.PA_UTILS dependencies on PA_PERIODS

Line 1363: FROM pa_periods pap

1359: -- or future period on or after the EI date...sparames Nov 14, 1997
1360:
1361: SELECT MIN(pap.end_date)
1362: INTO l_pa_date
1363: FROM pa_periods pap
1364: WHERE status in ('O','F')
1365: AND pap.end_date >= x_ei_date;
1366:
1367: return(l_pa_date) ;

Line 1381: -- date from the pa_periods table. The function created for

1377: -- Function : get_pa_end_date
1378: -- Derive the period end date based on the period name
1379: --
1380: -- This function accepts the period name and gets the period end
1381: -- date from the pa_periods table. The function created for
1382: -- burden cost accounting.
1383: -- Created by Sandeep 04-MAR-1998
1384: -----------------------------------------------------------------------
1385:

Line 1393: FROM pa_periods pap

1389: BEGIN
1390:
1391: SELECT pap.end_date
1392: INTO l_pa_end_date
1393: FROM pa_periods pap
1394: WHERE pap.period_name = x_pa_period_name;
1395:
1396: return(l_pa_end_date) ;
1397:

Line 1419: l_period_name pa_periods_all.period_name%TYPE;

1415: -------------------------------------------------------------------
1416:
1417: FUNCTION get_pa_period_name( x_ei_date IN date, x_gl_date IN date ) return varchar2
1418: IS
1419: l_period_name pa_periods_all.period_name%TYPE;
1420: BEGIN
1421:
1422: -- The PA date is derived as the end date of the earliest open or
1423: -- future PA period on or after the EI date. The GL date which is

Line 1427: SELECT pa_periods.period_name

1423: -- future PA period on or after the EI date. The GL date which is
1424: -- passed as a parameter to this function is not used at present but
1425: -- is retained for future use...sparames Nov 14,1997
1426:
1427: SELECT pa_periods.period_name
1428: INTO l_period_name
1429: FROM pa_periods
1430: WHERE pa_periods.end_Date =
1431: (SELECT MIN(pap.end_date)

Line 1429: FROM pa_periods

1425: -- is retained for future use...sparames Nov 14,1997
1426:
1427: SELECT pa_periods.period_name
1428: INTO l_period_name
1429: FROM pa_periods
1430: WHERE pa_periods.end_Date =
1431: (SELECT MIN(pap.end_date)
1432: FROM pa_periods pap
1433: WHERE status in ('O','F')

Line 1430: WHERE pa_periods.end_Date =

1426:
1427: SELECT pa_periods.period_name
1428: INTO l_period_name
1429: FROM pa_periods
1430: WHERE pa_periods.end_Date =
1431: (SELECT MIN(pap.end_date)
1432: FROM pa_periods pap
1433: WHERE status in ('O','F')
1434: AND pap.end_date >= x_ei_date)

Line 1432: FROM pa_periods pap

1428: INTO l_period_name
1429: FROM pa_periods
1430: WHERE pa_periods.end_Date =
1431: (SELECT MIN(pap.end_date)
1432: FROM pa_periods pap
1433: WHERE status in ('O','F')
1434: AND pap.end_date >= x_ei_date)
1435: AND status in ('O','F'); /* Added the check for bug #1550929 */
1436: