APPS.PAY_CA_YEER_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 3356: from per_periods_of_service

3352: /* The cursor cur_rl_dob retrieves the termination Date if any.*/
3353:
3354: cursor cur_rl_terminate ( cp_person_id in number ) is
3355: select actual_termination_date
3356: from per_periods_of_service
3357: where person_id = cp_person_id
3358: and actual_termination_date is not null;
3359:
3360: /* The cursor cur_rl_qpp_block is used to verify whether an employee has

Line 3913: from per_periods_of_service

3909: /* The cursor cur_rl_dob retrieves the termination Date if any.*/
3910:
3911: cursor cur_terminate ( cp_person_id in number ) is
3912: select actual_termination_date
3913: from per_periods_of_service
3914: where person_id = cp_person_id
3915: and actual_termination_date is not null;
3916:
3917: /* The cursor cur_cpp_block is used to verify whether an employee has