APPS.GHR_PROCESS_SF52 dependencies on GHR_NATURE_OF_ACTIONS

Line 2594: from ghr_pa_requests a, ghr_nature_of_actions noa

2590: order by 2,1;
2591:
2592: cursor c_get_par_id is
2593: select pa_request_id ,noa.order_of_processing
2594: from ghr_pa_requests a, ghr_nature_of_actions noa
2595: where person_id = l_person_id
2596: and effective_date = l_effective_date
2597: and pa_notification_id is null
2598: and approval_date is not null

Line 2627: from ghr_pa_requests a, ghr_nature_of_actions noa

2623: ---Local Procedure.
2624: PROCEDURE sub_proc_futr_sf52 is
2625: cursor c_get_par_id is
2626: select pa_request_id ,noa.order_of_processing
2627: from ghr_pa_requests a, ghr_nature_of_actions noa
2628: where person_id = l_person_id
2629: and effective_date = l_effective_date
2630: and pa_notification_id is null
2631: and approval_date is not null

Line 3567: l_retro_first_noa ghr_nature_of_actions.code%type;

3563: l_orig_pa_notification_id ghr_pa_requests.pa_notification_id%type;
3564: l_orig_person_id ghr_pa_requests.person_id%type;
3565: l_orig_effective_date ghr_pa_requests.effective_date%type;
3566: l_effective_date ghr_pa_requests.effective_date%type;
3567: l_retro_first_noa ghr_nature_of_actions.code%type;
3568: l_retro_second_noa ghr_nature_of_actions.code%type;
3569: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3570:
3571: CURSOR c_orig_rec(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

Line 3568: l_retro_second_noa ghr_nature_of_actions.code%type;

3564: l_orig_person_id ghr_pa_requests.person_id%type;
3565: l_orig_effective_date ghr_pa_requests.effective_date%type;
3566: l_effective_date ghr_pa_requests.effective_date%type;
3567: l_retro_first_noa ghr_nature_of_actions.code%type;
3568: l_retro_second_noa ghr_nature_of_actions.code%type;
3569: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3570:
3571: CURSOR c_orig_rec(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
3572: SELECT *