APPS.GHR_PDH_API dependencies on GHR_PD_ROUTING_HISTORY

Line 19: l_pdh_object_version_number ghr_pd_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_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
20: l_pdh_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
21: l_action_taken ghr_pd_routing_history.action_taken%type;
22:
23:

Line 20: l_pdh_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;

16: )is
17:
18: l_proc varchar2(72) := g_package|| 'upd_date_notif_sent' ;
19: l_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
20: l_pdh_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
21: l_action_taken ghr_pd_routing_history.action_taken%type;
22:
23:
24: cursor C_routing_history_id is

Line 21: l_action_taken ghr_pd_routing_history.action_taken%type;

17:
18: l_proc varchar2(72) := g_package|| 'upd_date_notif_sent' ;
19: l_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
20: l_pdh_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
21: l_action_taken ghr_pd_routing_history.action_taken%type;
22:
23:
24: cursor C_routing_history_id is
25: select pdh.pd_routing_history_id,

Line 28: from ghr_pd_routing_history pdh

24: cursor C_routing_history_id is
25: select pdh.pd_routing_history_id,
26: pdh.object_version_number,
27: pdh.action_taken
28: from ghr_pd_routing_history pdh
29: where pdh.position_description_id = p_position_description_id
30: order by pdh.pd_routing_history_id desc;
31:
32: begin