APPS.GHR_PROCESS_SF52 dependencies on GHR_NATURE_OF_ACTIONS

Line 2704: from ghr_pa_requests a, ghr_nature_of_actions noa

2700: order by 2,1;
2701:
2702: cursor c_get_par_id is
2703: select pa_request_id ,noa.order_of_processing
2704: from ghr_pa_requests a, ghr_nature_of_actions noa
2705: where person_id = l_person_id
2706: and effective_date = l_effective_date
2707: and pa_notification_id is null
2708: and approval_date is not null

Line 2737: from ghr_pa_requests a, ghr_nature_of_actions noa

2733: ---Local Procedure.
2734: PROCEDURE sub_proc_futr_sf52 is
2735: cursor c_get_par_id is
2736: select pa_request_id ,noa.order_of_processing
2737: from ghr_pa_requests a, ghr_nature_of_actions noa
2738: where person_id = l_person_id
2739: and effective_date = l_effective_date
2740: and pa_notification_id is null
2741: and approval_date is not null

Line 3697: l_retro_first_noa ghr_nature_of_actions.code%type;

3693: l_orig_pa_notification_id ghr_pa_requests.pa_notification_id%type;
3694: l_orig_person_id ghr_pa_requests.person_id%type;
3695: l_orig_effective_date ghr_pa_requests.effective_date%type;
3696: l_effective_date ghr_pa_requests.effective_date%type;
3697: l_retro_first_noa ghr_nature_of_actions.code%type;
3698: l_retro_second_noa ghr_nature_of_actions.code%type;
3699: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3700: l_orig_first_noa ghr_pa_requests.first_noa_code%type;
3701: l_orig_second_noa ghr_pa_requests.second_noa_code%type;

Line 3698: l_retro_second_noa ghr_nature_of_actions.code%type;

3694: l_orig_person_id ghr_pa_requests.person_id%type;
3695: l_orig_effective_date ghr_pa_requests.effective_date%type;
3696: l_effective_date ghr_pa_requests.effective_date%type;
3697: l_retro_first_noa ghr_nature_of_actions.code%type;
3698: l_retro_second_noa ghr_nature_of_actions.code%type;
3699: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3700: l_orig_first_noa ghr_pa_requests.first_noa_code%type;
3701: l_orig_second_noa ghr_pa_requests.second_noa_code%type;
3702: