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

178: --------------------------------------------------------------------+
179:
180: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
181: IS
182: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
183: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

179:
180: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
181: IS
182: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
183: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

180: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
181: IS
182: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
183: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

181: IS
182: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
183: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

182: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
183: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

183: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

185: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

186: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

187: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

188: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

189: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

190: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
198: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

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

191: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
198: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
199: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

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

192: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
198: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
199: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
200: FROM pay_payroll_actions ppa

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

193: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
198: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
199: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
200: FROM pay_payroll_actions ppa
201: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

194: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
198: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
199: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
200: FROM pay_payroll_actions ppa
201: WHERE ppa.payroll_action_id = c_payroll_action_id;
202:

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

195: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
198: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
199: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
200: FROM pay_payroll_actions ppa
201: WHERE ppa.payroll_action_id = c_payroll_action_id;
202:
203: --------------------------------------------------------------------+

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

796: --------------------------------------------------------------------+
797:
798: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
799: IS
800: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
801: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

797:
798: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
799: IS
800: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
801: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

798: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
799: IS
800: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
801: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

799: IS
800: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
801: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

800: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
801: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

801: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

803: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

804: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

805: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

806: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

807: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

808: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
816: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,

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

809: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
816: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
817: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/

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

810: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
816: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
817: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
818: FROM pay_payroll_actions ppa

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

811: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
816: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
817: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
818: FROM pay_payroll_actions ppa
819: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

812: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
816: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
817: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
818: FROM pay_payroll_actions ppa
819: WHERE ppa.payroll_action_id = c_payroll_action_id;
820:

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

813: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
816: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
817: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
818: FROM pay_payroll_actions ppa
819: WHERE ppa.payroll_action_id = c_payroll_action_id;
820:
821: --------------------------------------------------------------------+

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

2176: --------------------------------------------------------------------+
2177:
2178: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2179: IS
2180: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2181: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

2177:
2178: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2179: IS
2180: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2181: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,

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

2178: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2179: IS
2180: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2181: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,

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

2179: IS
2180: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2181: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,

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

2180: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2181: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,

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

2181: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,

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

2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,

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

2183: to_date(pay_core_utils.get_parameter('SDATE',legislative_parameters),'YYYY/MM/DD') start_date,
2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,

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

2184: to_date(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') end_date,
2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,

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

2185: pay_core_utils.get_parameter('PACTID',legislative_parameters) pact_id,
2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,

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

2186: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,

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

2187: pay_core_utils.get_parameter('ASG',legislative_parameters) assignment_id,
2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,

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

2188: pay_core_utils.get_parameter('SO1',legislative_parameters) sort_order_1,
2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,

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

2189: pay_core_utils.get_parameter('SO2',legislative_parameters) sort_order_2,
2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2197: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/

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

2190: pay_core_utils.get_parameter('SO3',legislative_parameters) sort_order_3,
2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2197: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2198: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */

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

2191: pay_core_utils.get_parameter('SO4',legislative_parameters) sort_order_4,
2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2197: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2198: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2199: FROM pay_payroll_actions ppa

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

2192: to_date(pay_core_utils.get_parameter('PEDATE',legislative_parameters),'YYYY/MM/DD') period_end_date,
2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2197: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2198: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2199: FROM pay_payroll_actions ppa
2200: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

2193: pay_core_utils.get_parameter('YTD_TOT',legislative_parameters) ytd_totals,
2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2197: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2198: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2199: FROM pay_payroll_actions ppa
2200: WHERE ppa.payroll_action_id = c_payroll_action_id;
2201:

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

2194: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2197: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2198: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2199: FROM pay_payroll_actions ppa
2200: WHERE ppa.payroll_action_id = c_payroll_action_id;
2201:
2202: