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 369: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,

365: --------------------------------------------------------------------+
366:
367: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
368: IS
369: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
370: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
371: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

366:
367: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
368: IS
369: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
370: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
371: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

367: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
368: IS
369: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
370: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
371: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

368: IS
369: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
370: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
371: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

369: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
370: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
371: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

370: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
371: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

371: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

372: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

373: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

374: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

375: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

376: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
384: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

377: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
384: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
385: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

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

378: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
384: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
385: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
386: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

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

379: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
384: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
385: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
386: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
387: FROM pay_payroll_actions ppa

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

380: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
384: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
385: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
386: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
387: FROM pay_payroll_actions ppa
388: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

381: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
384: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
385: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
386: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
387: FROM pay_payroll_actions ppa
388: WHERE ppa.payroll_action_id = c_payroll_action_id;
389:

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

382: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
383: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
384: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
385: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
386: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
387: FROM pay_payroll_actions ppa
388: WHERE ppa.payroll_action_id = c_payroll_action_id;
389:
390: --------------------------------------------------------------------+

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

1004: --------------------------------------------------------------------+
1005:
1006: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1007: IS
1008: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1009: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1010: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

1005:
1006: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1007: IS
1008: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1009: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1010: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

1006: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1007: IS
1008: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1009: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1010: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

1007: IS
1008: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1009: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1010: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

1008: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1009: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1010: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

1009: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1010: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

1010: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

1011: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

1012: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

1013: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

1014: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

1015: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1023: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

1016: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1023: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1024: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

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

1017: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1023: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1024: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1025: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

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

1018: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1023: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1024: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1025: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1026: FROM pay_payroll_actions ppa

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

1019: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1023: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1024: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1025: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1026: FROM pay_payroll_actions ppa
1027: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

1020: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1023: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1024: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1025: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1026: FROM pay_payroll_actions ppa
1027: WHERE ppa.payroll_action_id = c_payroll_action_id;
1028:

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

1021: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1022: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1023: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1024: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1025: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1026: FROM pay_payroll_actions ppa
1027: WHERE ppa.payroll_action_id = c_payroll_action_id;
1028:
1029: --------------------------------------------------------------------+

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

2114: --------------------------------------------------------------------+
2115:
2116: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2117: IS
2118: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2119: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2120: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

2115:
2116: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2117: IS
2118: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2119: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2120: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

2116: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2117: IS
2118: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2119: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2120: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

2117: IS
2118: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2119: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2120: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

2118: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2119: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2120: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

2119: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2120: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

2120: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

2121: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

2122: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

2123: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

2124: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

2125: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

2126: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2134: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,

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

2127: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2134: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2135: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/

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

2128: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2134: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2135: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2136: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 5174524*/

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

2129: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2134: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2135: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2136: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 5174524*/
2137: FROM pay_payroll_actions ppa

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

2130: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2134: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2135: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2136: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 5174524*/
2137: FROM pay_payroll_actions ppa
2138: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

2131: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2134: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2135: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2136: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 5174524*/
2137: FROM pay_payroll_actions ppa
2138: WHERE ppa.payroll_action_id = c_payroll_action_id;
2139:

Line 2136: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /Bug# 5174524/

2132: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2133: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2134: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2135: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2136: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) output_type /*Bug# 5174524*/
2137: FROM pay_payroll_actions ppa
2138: WHERE ppa.payroll_action_id = c_payroll_action_id;
2139:
2140: