DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_CORE_UTILS

Line 402: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('TAX_YEAR',legislative_parameters))

398: ,p_employer OUT NOCOPY NUMBER
399: ,p_org_struct_id OUT NOCOPY NUMBER ) IS
400: --
401: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
402: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('TAX_YEAR',legislative_parameters))
403: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
404: ,pay_core_utils.get_parameter('ORG_HIERARCHY',legislative_parameters)
405: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
406: ,effective_date

Line 403: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)

399: ,p_org_struct_id OUT NOCOPY NUMBER ) IS
400: --
401: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
402: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('TAX_YEAR',legislative_parameters))
403: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
404: ,pay_core_utils.get_parameter('ORG_HIERARCHY',legislative_parameters)
405: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
406: ,effective_date
407: ,business_group_id

Line 404: ,pay_core_utils.get_parameter('ORG_HIERARCHY',legislative_parameters)

400: --
401: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
402: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('TAX_YEAR',legislative_parameters))
403: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
404: ,pay_core_utils.get_parameter('ORG_HIERARCHY',legislative_parameters)
405: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
406: ,effective_date
407: ,business_group_id
408: FROM pay_payroll_actions

Line 405: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)

401: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
402: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('TAX_YEAR',legislative_parameters))
403: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
404: ,pay_core_utils.get_parameter('ORG_HIERARCHY',legislative_parameters)
405: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
406: ,effective_date
407: ,business_group_id
408: FROM pay_payroll_actions
409: WHERE payroll_action_id = p_payroll_action_id;