APPS.PQH_WORKFLOW dependencies on PER_PERIODS_OF_SERVICE

Line 4630: from per_periods_of_service ppos

4626: from fnd_user
4627: where user_id = p_user_id;
4628: cursor c_emp_term(p_date date) is
4629: select ppos.date_start, ppos.actual_termination_date
4630: from per_periods_of_service ppos
4631: where ppos.person_id = l_person_id
4632: and p_date between ppos.date_start and nvl(ppos.actual_termination_date, hr_general.end_of_time) ;
4633:
4634: cursor c_emp_date_start is

Line 4636: from per_periods_of_service ppos

4632: and p_date between ppos.date_start and nvl(ppos.actual_termination_date, hr_general.end_of_time) ;
4633:
4634: cursor c_emp_date_start is
4635: select min(ppos.date_start)
4636: from per_periods_of_service ppos
4637: where ppos.person_id = l_person_id;
4638:
4639: cursor c_user_action is
4640: select user_action_cd