[Home] [Help]
434: --
435: --
436: l_user_name ghr_pa_routing_history.user_name%TYPE;
437: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
438: l_groupbox_name ghr_groupboxes.name%TYPE;
439: l_subject varchar2(500);
440: l_line1 varchar2(500);
441: l_line2 varchar2(500);
442: l_line3 varchar2(500);
611: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
612: l_user_name ghr_pa_routing_history.user_name%TYPE;
613: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
614: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
615: l_groupbox_name ghr_groupboxes.name%TYPE;
616: --
617: --
618: cursor csr_pa_routing_history is
619: SELECT max(pa_routing_history_id)
626: WHERE pa_routing_history_id = l_pa_routing_history_id;
627: --
628: cursor csr_gbx_details is
629: SELECT name
630: FROM GHR_GROUPBOXES
631: WHERE GROUPBOX_ID = l_groupbox_id;
632: --
633: --
634: begin
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1342: l_gbx_id ghr_groupboxes.groupbox_id%type;
1343: --
1344: CURSOR chk_groupbox is
1345: select name,groupbox_id,display_name from ghr_groupboxes
1346: where routing_group_id = l_routing_group_id
1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1342: l_gbx_id ghr_groupboxes.groupbox_id%type;
1343: --
1344: CURSOR chk_groupbox is
1345: select name,groupbox_id,display_name from ghr_groupboxes
1346: where routing_group_id = l_routing_group_id
1347: and name = l_forward_to_name;
1348:
1349: CURSOR chk_groupbox_users is
1354: PERSONNELIST_FLAG,
1355: APPROVER_FLAG,
1356: REVIEWER_FLAG
1357: from ghr_groupbox_users
1358: where groupbox_id = ( select groupbox_id from ghr_groupboxes
1359: where routing_group_id = l_routing_group_id )
1360: and user_name = l_forward_to_name;
1361:
1362: