DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PAY_CORE_UTILS

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

1525: --
1526: -- TEST, TEST_ID, report_type and report_category added in cursor select
1527: -- for P45PT1. Bug 6345375
1528: cursor csr_get_payroll_param is
1529: select pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id,
1530: substr(pay_core_utils.get_parameter('TEST',legislative_parameters),1,1) test_indicator,
1531: trim(substr(pay_core_utils.get_parameter('TEST_ID',legislative_parameters),1,8)) test_id,
1532: report_type,
1533: report_category

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

1526: -- TEST, TEST_ID, report_type and report_category added in cursor select
1527: -- for P45PT1. Bug 6345375
1528: cursor csr_get_payroll_param is
1529: select pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id,
1530: substr(pay_core_utils.get_parameter('TEST',legislative_parameters),1,1) test_indicator,
1531: trim(substr(pay_core_utils.get_parameter('TEST_ID',legislative_parameters),1,8)) test_id,
1532: report_type,
1533: report_category
1534: from pay_payroll_actions ppa

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

1527: -- for P45PT1. Bug 6345375
1528: cursor csr_get_payroll_param is
1529: select pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id,
1530: substr(pay_core_utils.get_parameter('TEST',legislative_parameters),1,1) test_indicator,
1531: trim(substr(pay_core_utils.get_parameter('TEST_ID',legislative_parameters),1,8)) test_id,
1532: report_type,
1533: report_category
1534: from pay_payroll_actions ppa
1535: where ppa.payroll_action_id = pactid;