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_PAYROLL_ACTIONS

Line 81: token_val pay_payroll_actions.legislative_parameters%type;

77: parameter_list varchar2) return varchar2
78: is
79: start_ptr number;
80: end_ptr number;
81: token_val pay_payroll_actions.legislative_parameters%type;
82: par_value pay_payroll_actions.legislative_parameters%type;
83: begin
84: token_val := name||'=';
85: start_ptr := instr(parameter_list, token_val) + length(token_val);

Line 82: par_value pay_payroll_actions.legislative_parameters%type;

78: is
79: start_ptr number;
80: end_ptr number;
81: token_val pay_payroll_actions.legislative_parameters%type;
82: par_value pay_payroll_actions.legislative_parameters%type;
83: begin
84: token_val := name||'=';
85: start_ptr := instr(parameter_list, token_val) + length(token_val);
86: end_ptr := instr(parameter_list, ' ',start_ptr);

Line 141: from pay_payroll_actions ppa /* PYUGEN payroll action id */

137: l_per_id,
138: l_curp,
139: l_asg_set_id,
140: l_effective_date
141: from pay_payroll_actions ppa /* PYUGEN payroll action id */
142: where ppa.payroll_action_id = pactid ;
143: Exception
144: when no_data_found then
145: dbg('Legislative parameters not found for pactid '||to_char(pactid));

Line 152: from pay_payroll_actions ppa,

148:
149: dbg('Before the range cursor');
150:
151: sqlstr := 'select distinct to_number(paa.serial_number)
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 ||

Line 163: FROM pay_payroll_actions ppa1,

159: and paa.action_status =''C''
160: and :payroll_action_id is not null
161: and NOT EXISTS(
162: SELECT ''x''
163: FROM pay_payroll_actions ppa1,
164: pay_assignment_actions paa1,
165: pay_action_interlocks palock
166: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
167: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 268: FROM pay_payroll_actions ppa_arch,

264: pai.effective_date,
265: paa_arch.assignment_action_id,
266: paa_arch.assignment_id,
267: paa_arch.tax_unit_id
268: FROM pay_payroll_actions ppa_arch,
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''

Line 286: FROM pay_payroll_actions ppa1,

282: and pai.action_information_category = ''MX YREND EE DETAILS''
283: and pai.action_context_id = paa_arch.assignment_action_id
284: AND NOT EXISTS(
285: SELECT ''x''
286: FROM pay_payroll_actions ppa1,
287: pay_assignment_actions paa1,
288: pay_action_interlocks palock
289: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
290: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 310: FROM pay_payroll_actions ppa_arch,

306: pai.effective_date,
307: paa_arch.assignment_action_id,
308: paa_arch.assignment_id,
309: paa_arch.tax_unit_id
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)) = '

Line 325: FROM pay_payroll_actions ppa1,

321: and pai.action_information_category = ''MX YREND EE DETAILS''
322: and pai.action_context_id = paa_arch.assignment_action_id
323: AND NOT EXISTS(
324: SELECT ''x''
325: FROM pay_payroll_actions ppa1,
326: pay_assignment_actions paa1,
327: pay_action_interlocks palock
328: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
329: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 361: pay_payroll_actions ppa_arch,

357: paa_arch.assignment_id,
358: paa_arch.tax_unit_id
359: FROM per_periods_of_service pps,
360: per_assignments_f paf,
361: pay_payroll_actions ppa_arch,
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''

Line 391: FROM pay_payroll_actions ppa1,

387: and pai.action_information_category = ''MX YREND EE DETAILS''
388: and pai.action_context_id = paa_arch.assignment_action_id
389: AND NOT EXISTS(
390: SELECT ''x''
391: FROM pay_payroll_actions ppa1,
392: pay_assignment_actions paa1,
393: pay_action_interlocks palock
394: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
395: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 416: pay_payroll_actions ppa_arch,

412: paa_arch.assignment_id,
413: paa_arch.tax_unit_id
414: FROM per_periods_of_service pps,
415: per_assignments_f paf,
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)) = '

Line 443: FROM pay_payroll_actions ppa1,

439: and pai.action_information_category = ''MX YREND EE DETAILS''
440: and pai.action_context_id = paa_arch.assignment_action_id
441: AND NOT EXISTS(
442: SELECT ''x''
443: FROM pay_payroll_actions ppa1,
444: pay_assignment_actions paa1,
445: pay_action_interlocks palock
446: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
447: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 480: pay_payroll_actions ppa_arch,

476: paa_arch.assignment_id,
477: paa_arch.tax_unit_id
478: FROM per_periods_of_service pps,
479: per_assignments_f paf,
480: pay_payroll_actions ppa_arch,
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''

Line 510: FROM pay_payroll_actions ppa1,

506: and pai.action_information_category = ''MX YREND EE DETAILS''
507: and pai.action_context_id = paa_arch.assignment_action_id
508: AND NOT EXISTS(
509: SELECT ''x''
510: FROM pay_payroll_actions ppa1,
511: pay_assignment_actions paa1,
512: pay_action_interlocks palock
513: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
514: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 536: pay_payroll_actions ppa_arch,

532: paa_arch.assignment_id,
533: paa_arch.tax_unit_id
534: FROM per_periods_of_service pps,
535: per_assignments_f paf,
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)) = '

Line 563: FROM pay_payroll_actions ppa1,

559: and pai.action_information_category = ''MX YREND EE DETAILS''
560: and pai.action_context_id = paa_arch.assignment_action_id
561: AND NOT EXISTS(
562: SELECT ''x''
563: FROM pay_payroll_actions ppa1,
564: pay_assignment_actions paa1,
565: pay_action_interlocks palock
566: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
567: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 595: pay_payroll_actions ppa_arch,

591: paa_arch.assignment_action_id,
592: paa_arch.assignment_id,
593: paa_arch.tax_unit_id
594: FROM per_assignments_f paf,
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)) = '

Line 619: FROM pay_payroll_actions ppa1,

615: and pai.action_information_category = ''MX YREND EE DETAILS''
616: and pai.action_context_id = paa_arch.assignment_action_id
617: AND NOT EXISTS(
618: SELECT ''x''
619: FROM pay_payroll_actions ppa1,
620: pay_assignment_actions paa1,
621: pay_action_interlocks palock
622: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
623: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 652: pay_payroll_actions ppa_arch,

648: paa_arch.assignment_action_id,
649: paa_arch.assignment_id,
650: paa_arch.tax_unit_id
651: FROM per_assignments_f paf,
652: pay_payroll_actions ppa_arch,
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''

Line 677: FROM pay_payroll_actions ppa1,

673: and pai.action_information_category = ''MX YREND EE DETAILS''
674: and pai.action_context_id = paa_arch.assignment_action_id
675: AND NOT EXISTS(
676: SELECT ''x''
677: FROM pay_payroll_actions ppa1,
678: pay_assignment_actions paa1,
679: pay_action_interlocks palock
680: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
681: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 706: pay_payroll_actions ppa_arch,

702: paa_arch.assignment_action_id,
703: paa_arch.assignment_id,
704: paa_arch.tax_unit_id
705: FROM per_assignments_f paf,
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)) = '

Line 728: FROM pay_payroll_actions ppa1,

724: and pai.action_information_category = ''MX YREND EE DETAILS''
725: and pai.action_context_id = paa_arch.assignment_action_id
726: AND NOT EXISTS(
727: SELECT ''x''
728: FROM pay_payroll_actions ppa1,
729: pay_assignment_actions paa1,
730: pay_action_interlocks palock
731: WHERE paa1.payroll_action_id = ppa1.payroll_action_id
732: AND ppa1.report_type = ''ISR_TAX_FORMAT37''

Line 842: l_report_type pay_payroll_actions.report_type%TYPE;

838: l_per_id per_assignments_f.person_id%type;
839: l_curp per_people_f.national_identifier%type;
840: l_asg_set_id number;
841: l_effective_date date;
842: l_report_type pay_payroll_actions.report_type%TYPE;
843: l_report_category pay_payroll_actions.report_category%type;
844: l_report_qualifier pay_payroll_actions.report_qualifier%type;
845:
846: begin

Line 843: l_report_category pay_payroll_actions.report_category%type;

839: l_curp per_people_f.national_identifier%type;
840: l_asg_set_id number;
841: l_effective_date date;
842: l_report_type pay_payroll_actions.report_type%TYPE;
843: l_report_category pay_payroll_actions.report_category%type;
844: l_report_qualifier pay_payroll_actions.report_qualifier%type;
845:
846: begin
847:

Line 844: l_report_qualifier pay_payroll_actions.report_qualifier%type;

840: l_asg_set_id number;
841: l_effective_date date;
842: l_report_type pay_payroll_actions.report_type%TYPE;
843: l_report_category pay_payroll_actions.report_category%type;
844: l_report_qualifier pay_payroll_actions.report_qualifier%type;
845:
846: begin
847:
848: g_debug_flag := 'Y' ;

Line 877: from pay_payroll_actions ppa /* PYUGEN payroll action id */

873: l_effective_date,
874: l_report_type,
875: l_report_category,
876: l_report_qualifier
877: from pay_payroll_actions ppa /* PYUGEN payroll action id */
878: where ppa.payroll_action_id = pactid ;
879: Exception
880: when no_data_found then
881: dbg('Legislative parameters not found for pactid '||to_char(pactid));