eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_WGI_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 221: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;

217: l_days NUMBER := 350;
218: l_frequency NUMBER;
219: l_message_set BOOLEAN;
220: l_calculated BOOLEAN;
221: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
222: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
223: -- used for starting the wgi workflow
224: l_start_wgi_wf_flag CHAR (1) := 'N';
225: l_errbuf VARCHAR2 (2000);

Line 294: FROM ghr_nature_of_actions

290: SELECT noa_family_code
291: FROM ghr_noa_families
292: WHERE nature_of_action_id =
293: (SELECT nature_of_action_id
294: FROM ghr_nature_of_actions
295: WHERE code = l_first_noa_code
296: AND l_effective_date BETWEEN NVL(Date_from,l_effective_date)
297: AND NVL(date_to,l_effective_date)
298: )

Line 2174: p_code IN ghr_nature_of_actions.code%TYPE,

2170:
2171: --
2172: --
2173: PROCEDURE get_noa_code_desc (
2174: p_code IN ghr_nature_of_actions.code%TYPE,
2175: p_effective_date IN DATE DEFAULT SYSDATE,
2176: p_nature_of_action_id OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE,
2177: p_description OUT NOCOPY ghr_nature_of_actions.description%TYPE
2178: )

Line 2176: p_nature_of_action_id OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE,

2172: --
2173: PROCEDURE get_noa_code_desc (
2174: p_code IN ghr_nature_of_actions.code%TYPE,
2175: p_effective_date IN DATE DEFAULT SYSDATE,
2176: p_nature_of_action_id OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE,
2177: p_description OUT NOCOPY ghr_nature_of_actions.description%TYPE
2178: )
2179: IS
2180: --

Line 2177: p_description OUT NOCOPY ghr_nature_of_actions.description%TYPE

2173: PROCEDURE get_noa_code_desc (
2174: p_code IN ghr_nature_of_actions.code%TYPE,
2175: p_effective_date IN DATE DEFAULT SYSDATE,
2176: p_nature_of_action_id OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE,
2177: p_description OUT NOCOPY ghr_nature_of_actions.description%TYPE
2178: )
2179: IS
2180: --
2181: -- local variables

Line 2184: l_code ghr_nature_of_actions.code%TYPE;

2180: --
2181: -- local variables
2182: --
2183: l_effective_date DATE;
2184: l_code ghr_nature_of_actions.code%TYPE;
2185: l_description ghr_nature_of_actions.description%TYPE;
2186: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
2187:
2188: --

Line 2185: l_description ghr_nature_of_actions.description%TYPE;

2181: -- local variables
2182: --
2183: l_effective_date DATE;
2184: l_code ghr_nature_of_actions.code%TYPE;
2185: l_description ghr_nature_of_actions.description%TYPE;
2186: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
2187:
2188: --
2189: CURSOR csr_noa

Line 2186: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;

2182: --
2183: l_effective_date DATE;
2184: l_code ghr_nature_of_actions.code%TYPE;
2185: l_description ghr_nature_of_actions.description%TYPE;
2186: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
2187:
2188: --
2189: CURSOR csr_noa
2190: IS

Line 2192: FROM ghr_nature_of_actions noa

2188: --
2189: CURSOR csr_noa
2190: IS
2191: SELECT noa.nature_of_action_id, noa.description
2192: FROM ghr_nature_of_actions noa
2193: WHERE noa.code = l_code
2194: AND noa.enabled_flag = 'Y'
2195: AND NVL (l_effective_date, TRUNC (SYSDATE)) BETWEEN noa.date_from
2196: AND NVL (noa.date_to,