1025: Begin
1026:
1027: Select 'X'
1028: Into dummy
1029: From per_workforce_current_x
1030: Where person_id = x_requester_id;
1031:
1032: x_requester_current := TRUE;
1033:
2697: Begin
2698:
2699: Select 'X'
2700: Into dummy
2701: From per_workforce_current_x
2702: Where person_id = x_requester_id;
2703:
2704: x_requester_current := TRUE;
2705:
2721: Begin
2722:
2723: Select cwk.supervisor_id
2724: into x_manager_id
2725: From per_workforce_current_x cwk
2726: Where cwk.person_id = x_requester_id;
2727:
2728: Exception
2729: When no_data_found then null;