APPS.GHR_PRH_API dependencies on GHR_PA_ROUTING_HISTORY

Line 19: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

15: p_date_notification_sent in date default trunc(sysdate)
16: )is
17:
18: l_proc varchar2(72) := g_package|| 'upd_date_notif_sent' ;
19: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
20: l_prh_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
21: l_action_taken ghr_pa_routing_history.action_taken%type;
22:
23:

Line 20: l_prh_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

16: )is
17:
18: l_proc varchar2(72) := g_package|| 'upd_date_notif_sent' ;
19: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
20: l_prh_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
21: l_action_taken ghr_pa_routing_history.action_taken%type;
22:
23:
24: cursor C_routing_history_id is

Line 21: l_action_taken ghr_pa_routing_history.action_taken%type;

17:
18: l_proc varchar2(72) := g_package|| 'upd_date_notif_sent' ;
19: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
20: l_prh_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
21: l_action_taken ghr_pa_routing_history.action_taken%type;
22:
23:
24: cursor C_routing_history_id is
25: select prh.pa_routing_history_id,

Line 28: from ghr_pa_routing_history prh

24: cursor C_routing_history_id is
25: select prh.pa_routing_history_id,
26: prh.object_version_number,
27: prh.action_taken
28: from ghr_pa_routing_history prh
29: where prh.pa_request_id = p_pa_request_id
30: order by prh.pa_routing_history_id desc;
31:
32: begin