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 2178: p_code IN ghr_nature_of_actions.code%TYPE,

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

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

2176: --
2177: PROCEDURE get_noa_code_desc (
2178: p_code IN ghr_nature_of_actions.code%TYPE,
2179: p_effective_date IN DATE DEFAULT SYSDATE,
2180: p_nature_of_action_id OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE,
2181: p_description OUT NOCOPY ghr_nature_of_actions.description%TYPE
2182: )
2183: IS
2184: --

Line 2181: p_description OUT NOCOPY ghr_nature_of_actions.description%TYPE

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

Line 2188: l_code ghr_nature_of_actions.code%TYPE;

2184: --
2185: -- local variables
2186: --
2187: l_effective_date DATE;
2188: l_code ghr_nature_of_actions.code%TYPE;
2189: l_description ghr_nature_of_actions.description%TYPE;
2190: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
2191:
2192: --

Line 2189: l_description ghr_nature_of_actions.description%TYPE;

2185: -- local variables
2186: --
2187: l_effective_date DATE;
2188: l_code ghr_nature_of_actions.code%TYPE;
2189: l_description ghr_nature_of_actions.description%TYPE;
2190: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
2191:
2192: --
2193: CURSOR csr_noa

Line 2190: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;

2186: --
2187: l_effective_date DATE;
2188: l_code ghr_nature_of_actions.code%TYPE;
2189: l_description ghr_nature_of_actions.description%TYPE;
2190: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
2191:
2192: --
2193: CURSOR csr_noa
2194: IS

Line 2196: FROM ghr_nature_of_actions noa

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