DBA Data[Home] [Help]

APPS.HR_DM_INIT dependencies on PAY_ACTION_PARAMETERS

Line 6: -- from the table pay_action_parameters, using a parameter name of

2: /* $Header: perdmini.pkb 115.19 2004/03/24 08:29:10 mmudigon ship $ */
3:
4: -- ------------------------- check_custom_flex ------------------------
5: -- Description: Check if custom flex code use is enabled. This is determined
6: -- from the table pay_action_parameters, using a parameter name of
7: -- HR_DM_CUSTOM_AOL_CODE.
8: --
9: -- Input Parameters
10: --

Line 24: FROM pay_action_parameters

20: FUNCTION check_custom_flex RETURN VARCHAR2 IS
21: --
22: CURSOR csr_value IS
23: SELECT UPPER(parameter_value)
24: FROM pay_action_parameters
25: WHERE parameter_name = 'HR_DM_CUSTOM_AOL_CODE';
26:
27: l_retval VARCHAR2(80) := NULL;
28:

Line 36: -- read values from pay_action_parameters

32:
33: hr_dm_utility.message('ROUT','entry:hr_dm_init.check_custom_flex', 5);
34: hr_dm_utility.message('PARA','(none)', 10);
35:
36: -- read values from pay_action_parameters
37:
38: OPEN csr_value;
39: LOOP
40: FETCH csr_value INTO l_retval;