APPS.PAY_CA_YEER_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 2987: from per_periods_of_service

2983: /* The cursor cur_rl_dob retrieves the termination Date if any.*/
2984:
2985: cursor cur_rl_terminate ( cp_person_id in number ) is
2986: select actual_termination_date
2987: from per_periods_of_service
2988: where person_id = cp_person_id
2989: and actual_termination_date is not null;
2990:
2991: /* The cursor cur_rl_qpp_block is used to verify whether an employee has

Line 3448: from per_periods_of_service

3444: /* The cursor cur_rl_dob retrieves the termination Date if any.*/
3445:
3446: cursor cur_terminate ( cp_person_id in number ) is
3447: select actual_termination_date
3448: from per_periods_of_service
3449: where person_id = cp_person_id
3450: and actual_termination_date is not null;
3451:
3452: /* The cursor cur_cpp_block is used to verify whether an employee has