eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_RECONCILIATION_PKG dependencies on PAY_CORE_UTILS

Line 483: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,

479: --------------------------------------------------------------------+
480:
481: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
482: IS
483: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
484: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

Line 484: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,

480:
481: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
482: IS
483: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
484: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

Line 485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

481: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
482: IS
483: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
484: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

Line 486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,

482: IS
483: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
484: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

Line 487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

483: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
484: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

Line 488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

484: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

Line 489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

485: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

Line 490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

486: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

Line 491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

487: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

Line 492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

488: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

Line 493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

489: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

Line 494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

490: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

Line 495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

491: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
499: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

Line 496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

492: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
499: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
500: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

Line 497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

493: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
499: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
500: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
501: FROM pay_payroll_actions ppa

Line 498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

494: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
499: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
500: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
501: FROM pay_payroll_actions ppa
502: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 499: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

495: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
499: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
500: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
501: FROM pay_payroll_actions ppa
502: WHERE ppa.payroll_action_id = c_payroll_action_id;
503:

Line 500: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /Bug# 4142159/

496: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
497: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
498: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
499: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
500: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
501: FROM pay_payroll_actions ppa
502: WHERE ppa.payroll_action_id = c_payroll_action_id;
503:
504: --------------------------------------------------------------------+

Line 1646: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,

1642: --------------------------------------------------------------------+
1643:
1644: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1645: IS
1646: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1647: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

Line 1647: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,

1643:
1644: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1645: IS
1646: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1647: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

Line 1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

1644: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1645: IS
1646: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1647: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

Line 1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,

1645: IS
1646: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1647: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

Line 1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

1646: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1647: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

Line 1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

1647: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

Line 1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

1648: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

Line 1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

1649: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

Line 1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

1650: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

Line 1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

1651: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

Line 1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

1652: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

Line 1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

1653: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

Line 1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

1654: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1662: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

Line 1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

1655: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1662: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1663: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

Line 1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

1656: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1662: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1663: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1664: FROM pay_payroll_actions ppa

Line 1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

1657: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1662: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1663: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1664: FROM pay_payroll_actions ppa
1665: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 1662: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

1658: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1662: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1663: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1664: FROM pay_payroll_actions ppa
1665: WHERE ppa.payroll_action_id = c_payroll_action_id;
1666:

Line 1663: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /Bug# 4142159/

1659: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1660: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1661: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1662: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1663: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1664: FROM pay_payroll_actions ppa
1665: WHERE ppa.payroll_action_id = c_payroll_action_id;
1666:
1667: --------------------------------------------------------------------+

Line 3392: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,

3388: --------------------------------------------------------------------+
3389:
3390: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3391: IS
3392: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3393: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

Line 3393: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,

3389:
3390: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3391: IS
3392: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3393: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

Line 3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

3390: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3391: IS
3392: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3393: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

Line 3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,

3391: IS
3392: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3393: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

Line 3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

3392: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3393: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

Line 3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

3393: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

Line 3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

3394: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

Line 3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

3395: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

Line 3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

3396: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

Line 3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

3397: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

Line 3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

3398: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

Line 3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

3399: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

Line 3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

3400: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,

Line 3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

3401: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3409: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/

Line 3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

3402: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3409: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3410: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 4947424*/

Line 3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

3403: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3409: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3410: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 4947424*/
3411: FROM pay_payroll_actions ppa

Line 3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,

3404: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3409: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3410: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 4947424*/
3411: FROM pay_payroll_actions ppa
3412: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 3409: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /Bug# 4142159/

3405: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3409: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3410: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 4947424*/
3411: FROM pay_payroll_actions ppa
3412: WHERE ppa.payroll_action_id = c_payroll_action_id;
3413:

Line 3410: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /Bug# 4947424/

3406: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3407: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3408: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3409: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3410: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 4947424*/
3411: FROM pay_payroll_actions ppa
3412: WHERE ppa.payroll_action_id = c_payroll_action_id;
3413:
3414: