APPS.PSP_PAYTRN dependencies on PER_PERIODS_OF_SERVICE

Line 1640: -- Looks into per_periods_of_service for ending employment.

1636: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1637: end if;
1638:
1639:
1640: -- Looks into per_periods_of_service for ending employment.
1641: -- If found then split the sub-line in to two sub-lines and
1642: -- delete the existing sub-line.
1643:
1644: CREATE_SLINE_EMP_END_DATE(X_PAYROLL_LINE_ID => l_line_id,

Line 2158: FROM per_periods_of_service

2154:
2155:
2156: CURSOR get_asg_begin_date_csr IS
2157: SELECT min(date_start)
2158: FROM per_periods_of_service
2159: WHERE person_id = x_person_id and
2160: (date_start between g_start_date and g_end_date) ;
2161: */
2162:

Line 2255: FROM per_periods_of_service

2251:
2252:
2253: CURSOR get_asg_begin_date_csr IS
2254: SELECT min(date_start)
2255: FROM per_periods_of_service
2256: WHERE person_id = x_person_id and
2257: (date_start between g_start_date and g_end_date) ;
2258:
2259: l_begin_date date;

Line 4198: FROM per_periods_of_service

4194: x_return_status OUT NOCOPY VARCHAR2) IS
4195:
4196: CURSOR check_service_period_begin_csr IS
4197: SELECT date_start
4198: FROM per_periods_of_service
4199: WHERE person_id = x_person_id and
4200: (date_start between g_start_date and g_end_date) ;
4201:
4202: l_date_start date;

Line 4206: FROM per_periods_of_service

4202: l_date_start date;
4203:
4204: CURSOR check_service_period_end_csr IS
4205: SELECT actual_termination_date
4206: FROM per_periods_of_service
4207: WHERE person_id = x_person_id and
4208: (date_start between g_start_date and g_end_date) ;
4209:
4210: l_actual_termination_date date;