DBA Data[Home] [Help]

APPS.PAY_FR_ARC_UTL dependencies on PAY_ACTION_PARAMETERS

Line 16: from pay_action_parameters

12: FUNCTION range_person_enh_enabled(p_payroll_action_id number) RETURN BOOLEAN IS
13: --
14: CURSOR csr_action_parameter is
15: select parameter_value
16: from pay_action_parameters
17: where parameter_name = 'RANGE_PERSON_ID';
18: --
19: CURSOR csr_range_format_param is
20: select par.parameter_value

Line 33: l_action_param_val pay_action_parameters.parameter_value%TYPE;

29: and map.effective_end_date
30: and map.report_format_mapping_id = par.report_format_mapping_id
31: and par.parameter_name = 'RANGE_PERSON_ID';
32: --
33: l_action_param_val pay_action_parameters.parameter_value%TYPE;
34: l_report_param_val pay_report_format_parameters.parameter_value%TYPE;
35: l_proc CONSTANT VARCHAR2(62):= g_package||'.range_person_enh_enabled';
36: --
37: BEGIN