DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PAY_CORE_UTILS

Line 1412: select pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id,

1408: --
1409: -- TEST, TEST_ID, report_type and report_category added in cursor select
1410: -- for P45PT1. Bug 6345375
1411: cursor csr_get_payroll_param is
1412: select pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id,
1413: substr(pay_core_utils.get_parameter('TEST',legislative_parameters),1,1) test_indicator,
1414: trim(substr(pay_core_utils.get_parameter('TEST_ID',legislative_parameters),1,8)) test_id,
1415: report_type,
1416: report_category

Line 1413: substr(pay_core_utils.get_parameter('TEST',legislative_parameters),1,1) test_indicator,

1409: -- TEST, TEST_ID, report_type and report_category added in cursor select
1410: -- for P45PT1. Bug 6345375
1411: cursor csr_get_payroll_param is
1412: select pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id,
1413: substr(pay_core_utils.get_parameter('TEST',legislative_parameters),1,1) test_indicator,
1414: trim(substr(pay_core_utils.get_parameter('TEST_ID',legislative_parameters),1,8)) test_id,
1415: report_type,
1416: report_category
1417: from pay_payroll_actions ppa

Line 1414: trim(substr(pay_core_utils.get_parameter('TEST_ID',legislative_parameters),1,8)) test_id,

1410: -- for P45PT1. Bug 6345375
1411: cursor csr_get_payroll_param is
1412: select pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id,
1413: substr(pay_core_utils.get_parameter('TEST',legislative_parameters),1,1) test_indicator,
1414: trim(substr(pay_core_utils.get_parameter('TEST_ID',legislative_parameters),1,8)) test_id,
1415: report_type,
1416: report_category
1417: from pay_payroll_actions ppa
1418: where ppa.payroll_action_id = pactid;