930: -- Cursor to get legislative parameters from the archive request
931:
932: CURSOR csr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
933: IS
934: SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
935: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
936: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
937: pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
938: pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
931:
932: CURSOR csr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
933: IS
934: SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
935: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
936: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
937: pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
938: pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
939: FROM pay_payroll_actions ppa
932: CURSOR csr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
933: IS
934: SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
935: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
936: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
937: pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
938: pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
939: FROM pay_payroll_actions ppa
940: WHERE ppa.payroll_action_id = p_payroll_action_id;
933: IS
934: SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
935: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
936: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
937: pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
938: pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
939: FROM pay_payroll_actions ppa
940: WHERE ppa.payroll_action_id = p_payroll_action_id;
941:
934: SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
935: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
936: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
937: pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
938: pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
939: FROM pay_payroll_actions ppa
940: WHERE ppa.payroll_action_id = p_payroll_action_id;
941:
942: BEGIN