36: ,p_density OUT NOCOPY NUMBER
37: ) IS
38: --
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
37: ) IS
38: --
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
38: --
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
47: ,business_group_id
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
47: ,business_group_id
48: FROM pay_payroll_actions
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
47: ,business_group_id
48: FROM pay_payroll_actions
49: WHERE payroll_action_id = p_payroll_action_id;