APPS.PA_UTILS dependencies on PA_PERIODS

Line 1119: FROM pa_periods pap

1115: -- or future period on or after the EI date...sparames Nov 14, 1997
1116:
1117: SELECT MIN(pap.end_date)
1118: INTO l_pa_date
1119: FROM pa_periods pap
1120: WHERE status in ('O','F')
1121: AND pap.end_date >= x_ei_date;
1122:
1123: return(l_pa_date) ;

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

1133: -- Function : get_pa_end_date
1134: -- Derive the period end date based on the period name
1135: --
1136: -- This function accepts the period name and gets the period end
1137: -- date from the pa_periods table. The function created for
1138: -- burden cost accounting.
1139: -- Created by Sandeep 04-MAR-1998
1140: -----------------------------------------------------------------------
1141:

Line 1149: FROM pa_periods pap

1145: BEGIN
1146:
1147: SELECT pap.end_date
1148: INTO l_pa_end_date
1149: FROM pa_periods pap
1150: WHERE pap.period_name = x_pa_period_name;
1151:
1152: return(l_pa_end_date) ;
1153:

Line 1175: l_period_name pa_periods_all.period_name%TYPE;

1171: -------------------------------------------------------------------
1172:
1173: FUNCTION get_pa_period_name( x_ei_date IN date, x_gl_date IN date ) return varchar2
1174: IS
1175: l_period_name pa_periods_all.period_name%TYPE;
1176: BEGIN
1177:
1178: -- The PA date is derived as the end date of the earliest open or
1179: -- future PA period on or after the EI date. The GL date which is

Line 1183: SELECT pa_periods.period_name

1179: -- future PA period on or after the EI date. The GL date which is
1180: -- passed as a parameter to this function is not used at present but
1181: -- is retained for future use...sparames Nov 14,1997
1182:
1183: SELECT pa_periods.period_name
1184: INTO l_period_name
1185: FROM pa_periods
1186: WHERE pa_periods.end_Date =
1187: (SELECT MIN(pap.end_date)

Line 1185: FROM pa_periods

1181: -- is retained for future use...sparames Nov 14,1997
1182:
1183: SELECT pa_periods.period_name
1184: INTO l_period_name
1185: FROM pa_periods
1186: WHERE pa_periods.end_Date =
1187: (SELECT MIN(pap.end_date)
1188: FROM pa_periods pap
1189: WHERE status in ('O','F')

Line 1186: WHERE pa_periods.end_Date =

1182:
1183: SELECT pa_periods.period_name
1184: INTO l_period_name
1185: FROM pa_periods
1186: WHERE pa_periods.end_Date =
1187: (SELECT MIN(pap.end_date)
1188: FROM pa_periods pap
1189: WHERE status in ('O','F')
1190: AND pap.end_date >= x_ei_date)

Line 1188: FROM pa_periods pap

1184: INTO l_period_name
1185: FROM pa_periods
1186: WHERE pa_periods.end_Date =
1187: (SELECT MIN(pap.end_date)
1188: FROM pa_periods pap
1189: WHERE status in ('O','F')
1190: AND pap.end_date >= x_ei_date)
1191: AND status in ('O','F'); /* Added the check for bug #1550929 */
1192: