APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 13: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,

9:
10:
11: PROCEDURE get_noa_code_desc
12: (
13: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
14: p_effective_date in date default trunc(sysdate),
15: p_noa_code out nocopy ghr_nature_of_actions.code%type,
16: p_noa_desc out nocopy ghr_nature_of_actions.description%type
17: )

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

11: PROCEDURE get_noa_code_desc
12: (
13: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
14: p_effective_date in date default trunc(sysdate),
15: p_noa_code out nocopy ghr_nature_of_actions.code%type,
16: p_noa_desc out nocopy ghr_nature_of_actions.description%type
17: )
18: IS
19:

Line 16: p_noa_desc out nocopy ghr_nature_of_actions.description%type

12: (
13: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
14: p_effective_date in date default trunc(sysdate),
15: p_noa_code out nocopy ghr_nature_of_actions.code%type,
16: p_noa_desc out nocopy ghr_nature_of_actions.description%type
17: )
18: IS
19:
20: --

Line 28: from ghr_nature_of_actions noa

24: l_proc varchar2(72) := g_package || 'get_noa_code_desc';
25:
26: cursor c_noa is
27: select noa.code, noa.description
28: from ghr_nature_of_actions noa
29: where noa.nature_of_action_id = p_noa_id
30: and noa.enabled_flag = 'Y'
31: and nvl(p_effective_date,trunc(sysdate))
32: between noa.date_from