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_MX_ISR_FORMAT37 dependencies on PAY_MX_ISR_FORMAT37

Line 1: PACKAGE body pay_mx_isr_format37 AS

1: PACKAGE body pay_mx_isr_format37 AS
2: /* $Header: paymxformat37mt.pkb 120.2 2005/11/15 13:13:42 kthirmiy noship $ */
3:
4: /*
5: +=====================================================================+

Line 125: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),

121: g_debug_flag := 'Y' ;
122: -- g_concurrent_flag := 'Y' ;
123:
124: begin
125: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
126: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),

Line 126: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),

122: -- g_concurrent_flag := 'Y' ;
123:
124: begin
125: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
126: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
130: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),

Line 127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),

123:
124: begin
125: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
126: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
130: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
131: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),

Line 128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),

124: begin
125: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
126: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
130: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
131: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
132: ppa.effective_date

Line 129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),

125: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
126: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
130: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
131: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
132: ppa.effective_date
133: into l_year,

Line 130: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),

126: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
130: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
131: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
132: ppa.effective_date
133: into l_year,
134: l_legal_employer_id,

Line 131: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),

127: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
128: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
129: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
130: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
131: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
132: ppa.effective_date
133: into l_year,
134: l_legal_employer_id,
135: l_org_id,

Line 156: and pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa.legislative_parameters) = ' || l_legal_employer_id ||

152: from pay_payroll_actions ppa,
153: pay_assignment_actions paa
154: where ppa.report_type = ''MX_YREND_ARCHIVE''
155: and ppa.action_status = ''C''
156: and pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa.legislative_parameters) = ' || l_legal_employer_id ||
157: ' and to_number(to_char(ppa.effective_date,''YYYY'')) = ' || l_year ||
158: ' and paa.payroll_action_id = ppa.payroll_action_id
159: and paa.action_status =''C''
160: and :payroll_action_id is not null

Line 171: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

167: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
168: AND ppa1.report_qualifier = ''DEFAULT''
169: AND ppa1.report_category = ''REPORT''
170: AND paa1.action_status = ''C''
171: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
172: || l_legal_employer_id ||
173: ' AND to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || l_year ||
174: ' AND palock.locking_action_id = paa1.assignment_action_id
175: and palock.locked_action_id = paa.assignment_action_id )

Line 273: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

269: pay_assignment_actions paa_arch,
270: pay_action_information pai,
271: pay_population_ranges ppr
272: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
273: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
274: || p_legal_employer_id ||
275: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
276: ' AND ppa_arch.action_status =''C''
277: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 294: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

290: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
291: AND ppa1.report_qualifier = ''DEFAULT''
292: AND ppa1.report_category = ''REPORT''
293: AND paa1.action_status = ''C''
294: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
295: || p_legal_employer_id ||
296: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
297: ' AND palock.locking_action_id = paa1.assignment_action_id
298: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 314: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

310: FROM pay_payroll_actions ppa_arch,
311: pay_assignment_actions paa_arch,
312: pay_action_information pai
313: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
314: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
315: || p_legal_employer_id ||
316: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
317: ' AND ppa_arch.action_status =''C''
318: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 333: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

329: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
330: AND ppa1.report_qualifier = ''DEFAULT''
331: AND ppa1.report_category = ''REPORT''
332: AND paa1.action_status = ''C''
333: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
334: || p_legal_employer_id ||
335: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
336: ' AND palock.locking_action_id = paa1.assignment_action_id
337: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 366: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

362: pay_assignment_actions paa_arch,
363: pay_action_information pai,
364: pay_population_ranges ppr
365: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
366: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
367: || p_legal_employer_id ||
368: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
369: ' AND ppa_arch.action_status =''C''
370: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 399: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

395: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
396: AND ppa1.report_qualifier = ''DEFAULT''
397: AND ppa1.report_category = ''REPORT''
398: AND paa1.action_status = ''C''
399: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
400: || p_legal_employer_id ||
401: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
402: ' AND palock.locking_action_id = paa1.assignment_action_id
403: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 420: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

416: pay_payroll_actions ppa_arch,
417: pay_assignment_actions paa_arch,
418: pay_action_information pai
419: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
420: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
421: || p_legal_employer_id ||
422: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
423: ' AND ppa_arch.action_status =''C''
424: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 451: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

447: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
448: AND ppa1.report_qualifier = ''DEFAULT''
449: AND ppa1.report_category = ''REPORT''
450: AND paa1.action_status = ''C''
451: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
452: || p_legal_employer_id ||
453: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
454: ' AND palock.locking_action_id = paa1.assignment_action_id
455: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 485: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

481: pay_assignment_actions paa_arch,
482: pay_action_information pai,
483: pay_population_ranges ppr
484: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
485: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
486: || p_legal_employer_id ||
487: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
488: ' AND ppa_arch.action_status =''C''
489: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 518: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

514: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
515: AND ppa1.report_qualifier = ''DEFAULT''
516: AND ppa1.report_category = ''REPORT''
517: AND paa1.action_status = ''C''
518: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
519: || p_legal_employer_id ||
520: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
521: ' AND palock.locking_action_id = paa1.assignment_action_id
522: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 540: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

536: pay_payroll_actions ppa_arch,
537: pay_assignment_actions paa_arch,
538: pay_action_information pai
539: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
540: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
541: || p_legal_employer_id ||
542: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
543: ' AND ppa_arch.action_status =''C''
544: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 571: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

567: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
568: AND ppa1.report_qualifier = ''DEFAULT''
569: AND ppa1.report_category = ''REPORT''
570: AND paa1.action_status = ''C''
571: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
572: || p_legal_employer_id ||
573: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
574: ' AND palock.locking_action_id = paa1.assignment_action_id
575: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 599: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

595: pay_payroll_actions ppa_arch,
596: pay_assignment_actions paa_arch,
597: pay_action_information pai
598: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
599: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
600: || p_legal_employer_id ||
601: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
602: ' AND ppa_arch.action_status =''C''
603: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 627: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

623: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
624: AND ppa1.report_qualifier = ''DEFAULT''
625: AND ppa1.report_category = ''REPORT''
626: AND paa1.action_status = ''C''
627: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
628: || p_legal_employer_id ||
629: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
630: ' AND palock.locking_action_id = paa1.assignment_action_id
631: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 657: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

653: pay_assignment_actions paa_arch,
654: pay_action_information pai,
655: pay_population_ranges ppr
656: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
657: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
658: || p_legal_employer_id ||
659: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
660: ' AND ppa_arch.action_status =''C''
661: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 685: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

681: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
682: AND ppa1.report_qualifier = ''DEFAULT''
683: AND ppa1.report_category = ''REPORT''
684: AND paa1.action_status = ''C''
685: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
686: || p_legal_employer_id ||
687: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
688: ' AND palock.locking_action_id = paa1.assignment_action_id
689: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 710: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

706: pay_payroll_actions ppa_arch,
707: pay_assignment_actions paa_arch,
708: pay_action_information pai
709: WHERE ppa_arch.report_type=''MX_YREND_ARCHIVE''
710: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '
711: || p_legal_employer_id ||
712: ' and to_number(to_char(ppa_arch.effective_date,''YYYY'')) = ' || p_year ||
713: ' AND ppa_arch.action_status =''C''
714: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 736: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='

732: AND ppa1.report_type = ''ISR_TAX_FORMAT37''
733: AND ppa1.report_qualifier = ''DEFAULT''
734: AND ppa1.report_category = ''REPORT''
735: AND paa1.action_status = ''C''
736: AND to_number(pay_mx_isr_format37.get_parameter(''LEGAL_EMPLOYER_ID'',ppa1.legislative_parameters)) ='
737: || p_legal_employer_id ||
738: ' and to_number(to_char(ppa1.effective_date,''YYYY'')) = ' || p_year ||
739: ' AND palock.locking_action_id = paa1.assignment_action_id
740: and palock.locked_action_id = paa_arch.assignment_action_id )

Line 855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),

851: -- hr_utility.trace_on(null,'ORACLE');
852: hr_utility.set_location('procpyr',1);
853: dbg('In the action cursor');
854: Begin
855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),

Line 856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),

852: hr_utility.set_location('procpyr',1);
853: dbg('In the action cursor');
854: Begin
855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
860: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),

Line 857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),

853: dbg('In the action cursor');
854: Begin
855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
860: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
861: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),

Line 858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),

854: Begin
855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
860: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
861: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
862: ppa.effective_date,

Line 859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),

855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
860: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
861: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
862: ppa.effective_date,
863: ppa.report_type,

Line 860: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),

856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),
857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
860: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
861: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
862: ppa.effective_date,
863: ppa.report_type,
864: ppa.report_category,

Line 861: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),

857: to_number(pay_mx_isr_format37.get_parameter('ORG_ID',ppa.legislative_parameters)),
858: to_number(pay_mx_isr_format37.get_parameter('LOC_ID',ppa.legislative_parameters)),
859: to_number(pay_mx_isr_format37.get_parameter('PER_ID',ppa.legislative_parameters)),
860: pay_mx_isr_format37.get_parameter('CURP',ppa.legislative_parameters),
861: to_number(pay_mx_isr_format37.get_parameter('ASG_SET',ppa.legislative_parameters)),
862: ppa.effective_date,
863: ppa.report_type,
864: ppa.report_category,
865: ppa.report_qualifier

Line 918: end pay_mx_isr_format37;

914:
915: end action_creation;
916:
917:
918: end pay_mx_isr_format37;