APPS.PAY_FR_ARC_UTL dependencies on PAY_REPORT_FORMAT_PARAMETERS

Line 23: pay_report_format_parameters par

19: CURSOR csr_range_format_param is
20: select par.parameter_value
21: from pay_payroll_actions ppa,
22: pay_report_format_mappings_f map,
23: pay_report_format_parameters par
24: where ppa.payroll_action_id = p_payroll_action_id
25: and map.report_type = ppa.report_type
26: and map.report_category = ppa.report_category
27: and map.report_qualifier = ppa.report_qualifier

Line 34: l_report_param_val pay_report_format_parameters.parameter_value%TYPE;

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
38: hr_utility.set_location('Entering: ' || l_proc,10);