DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 25: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,

21: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
22:
23: PROCEDURE get_noa_code_desc
24: (
25: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
26: p_effective_date in date default trunc(sysdate),
27: p_noa_code out nocopy ghr_nature_of_actions.code%type,
28: p_noa_desc out nocopy ghr_nature_of_actions.description%type
29: );

Line 27: p_noa_code out nocopy ghr_nature_of_actions.code%type,

23: PROCEDURE get_noa_code_desc
24: (
25: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
26: p_effective_date in date default trunc(sysdate),
27: p_noa_code out nocopy ghr_nature_of_actions.code%type,
28: p_noa_desc out nocopy ghr_nature_of_actions.description%type
29: );
30:
31: FUNCTION get_noa_id (

Line 28: p_noa_desc out nocopy ghr_nature_of_actions.description%type

24: (
25: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
26: p_effective_date in date default trunc(sysdate),
27: p_noa_code out nocopy ghr_nature_of_actions.code%type,
28: p_noa_desc out nocopy ghr_nature_of_actions.description%type
29: );
30:
31: FUNCTION get_noa_id (
32: p_mass_award_id in ghr_mass_awards.mass_award_id%type)