APPS.PSP_PAYTRN dependencies on PER_PERIODS_OF_SERVICE

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

1698: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1699: end if;
1700:
1701:
1702: -- Looks into per_periods_of_service for ending employment.
1703: -- If found then split the sub-line in to two sub-lines and
1704: -- delete the existing sub-line.
1705:
1706: CREATE_SLINE_EMP_END_DATE(X_PAYROLL_LINE_ID => l_line_id,

Line 2232: FROM per_periods_of_service

2228:
2229:
2230: CURSOR get_asg_begin_date_csr IS
2231: SELECT min(date_start)
2232: FROM per_periods_of_service
2233: WHERE person_id = x_person_id and
2234: (date_start between g_start_date and g_end_date) ;
2235: */
2236:

Line 2329: FROM per_periods_of_service

2325:
2326:
2327: CURSOR get_asg_begin_date_csr IS
2328: SELECT min(date_start)
2329: FROM per_periods_of_service
2330: WHERE person_id = x_person_id and
2331: (date_start between g_start_date and g_end_date) ;
2332:
2333: l_begin_date date;

Line 4272: FROM per_periods_of_service

4268: x_return_status OUT NOCOPY VARCHAR2) IS
4269:
4270: CURSOR check_service_period_begin_csr IS
4271: SELECT date_start
4272: FROM per_periods_of_service
4273: WHERE person_id = x_person_id and
4274: (date_start between g_start_date and g_end_date) ;
4275:
4276: l_date_start date;

Line 4280: FROM per_periods_of_service

4276: l_date_start date;
4277:
4278: CURSOR check_service_period_end_csr IS
4279: SELECT actual_termination_date
4280: FROM per_periods_of_service
4281: WHERE person_id = x_person_id and
4282: (date_start between g_start_date and g_end_date) ;
4283:
4284: l_actual_termination_date date;