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_REC_DET_ARCHIVE dependencies on PAY_CORE_UTILS

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

250: --------------------------------------------------------------------+
251:
252: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
253: IS
254: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
255: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
256: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

251:
252: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
253: IS
254: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
255: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
256: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

252: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
253: IS
254: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
255: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
256: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

253: IS
254: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
255: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
256: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

254: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
255: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
256: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

255: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
256: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

256: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

257: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

258: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

259: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

260: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

261: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
269: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

262: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
269: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
270: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

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

263: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
269: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
270: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
271: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

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

264: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
269: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
270: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
271: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
272: FROM pay_payroll_actions ppa

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

265: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
269: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
270: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
271: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
272: FROM pay_payroll_actions ppa
273: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

266: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
269: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
270: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
271: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
272: FROM pay_payroll_actions ppa
273: WHERE ppa.payroll_action_id = c_payroll_action_id;
274:

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

267: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
268: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
269: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
270: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
271: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
272: FROM pay_payroll_actions ppa
273: WHERE ppa.payroll_action_id = c_payroll_action_id;
274:
275: --------------------------------------------------------------------+

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

1367: --------------------------------------------------------------------+
1368:
1369: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1370: IS
1371: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1372: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1373: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

1368:
1369: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1370: IS
1371: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1372: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1373: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

1369: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1370: IS
1371: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1372: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1373: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

1370: IS
1371: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1372: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1373: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

1371: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
1372: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1373: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

1372: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
1373: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

1373: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

1374: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

1375: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

1376: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

1377: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

1378: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1386: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

1379: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1386: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1387: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

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

1380: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1386: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1387: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1388: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

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

1381: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1386: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1387: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1388: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1389: FROM pay_payroll_actions ppa

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

1382: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1386: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1387: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1388: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1389: FROM pay_payroll_actions ppa
1390: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

1383: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1386: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1387: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1388: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1389: FROM pay_payroll_actions ppa
1390: WHERE ppa.payroll_action_id = c_payroll_action_id;
1391:

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

1384: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
1385: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
1386: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
1387: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
1388: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
1389: FROM pay_payroll_actions ppa
1390: WHERE ppa.payroll_action_id = c_payroll_action_id;
1391:
1392: --------------------------------------------------------------------+

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

3380: --------------------------------------------------------------------+
3381:
3382: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3383: IS
3384: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3385: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3386: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

3381:
3382: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3383: IS
3384: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3385: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3386: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

3382: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3383: IS
3384: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3385: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3386: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

3383: IS
3384: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3385: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3386: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

3384: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
3385: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3386: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

3385: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
3386: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

3386: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

3387: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

3388: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

3389: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

3390: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

3391: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

3392: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3400: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,

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

3393: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3400: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3401: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/

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

3394: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3400: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3401: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3402: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */

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

3395: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3400: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3401: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3402: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3403: FROM pay_payroll_actions ppa

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

3396: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3400: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3401: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3402: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3403: FROM pay_payroll_actions ppa
3404: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

3397: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3400: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3401: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3402: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3403: FROM pay_payroll_actions ppa
3404: WHERE ppa.payroll_action_id = c_payroll_action_id;
3405:

Line 3402: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */

3398: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
3399: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
3400: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
3401: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
3402: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3403: FROM pay_payroll_actions ppa
3404: WHERE ppa.payroll_action_id = c_payroll_action_id;
3405:
3406: