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_ASSIGNMENT_ACTIONS

Line 111: l_legal_employer_id pay_assignment_actions.tax_unit_id%type;

107: ******************************************************************/
108: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
109:
110: l_year number ;
111: l_legal_employer_id pay_assignment_actions.tax_unit_id%type;
112: l_org_id per_assignments_f.organization_id%type;
113: l_loc_id per_assignments_f.location_id%type;
114: l_per_id per_assignments_f.person_id%type;
115: l_curp per_people_f.national_identifier%type;

Line 153: pay_assignment_actions paa

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 ||
157: ' and to_number(to_char(ppa.effective_date,''YYYY'')) = ' || l_year ||

Line 164: pay_assignment_actions paa1,

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''
168: AND ppa1.report_qualifier = ''DEFAULT''

Line 269: pay_assignment_actions paa_arch,

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''
273: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

Line 287: pay_assignment_actions paa1,

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''
291: AND ppa1.report_qualifier = ''DEFAULT''

Line 311: pay_assignment_actions paa_arch,

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)) = '
315: || p_legal_employer_id ||

Line 326: pay_assignment_actions paa1,

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''
330: AND ppa1.report_qualifier = ''DEFAULT''

Line 362: pay_assignment_actions paa_arch,

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''
366: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

Line 392: pay_assignment_actions paa1,

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''
396: AND ppa1.report_qualifier = ''DEFAULT''

Line 417: pay_assignment_actions paa_arch,

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)) = '
421: || p_legal_employer_id ||

Line 444: pay_assignment_actions paa1,

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''
448: AND ppa1.report_qualifier = ''DEFAULT''

Line 481: pay_assignment_actions paa_arch,

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''
485: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

Line 511: pay_assignment_actions paa1,

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''
515: AND ppa1.report_qualifier = ''DEFAULT''

Line 537: pay_assignment_actions paa_arch,

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)) = '
541: || p_legal_employer_id ||

Line 564: pay_assignment_actions paa1,

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''
568: AND ppa1.report_qualifier = ''DEFAULT''

Line 596: pay_assignment_actions paa_arch,

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)) = '
600: || p_legal_employer_id ||

Line 620: pay_assignment_actions paa1,

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''
624: AND ppa1.report_qualifier = ''DEFAULT''

Line 653: pay_assignment_actions paa_arch,

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''
657: AND to_number(pay_mx_isr_format37.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',ppa_arch.legislative_parameters)) = '

Line 678: pay_assignment_actions paa1,

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''
682: AND ppa1.report_qualifier = ''DEFAULT''

Line 707: pay_assignment_actions paa_arch,

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)) = '
711: || p_legal_employer_id ||

Line 729: pay_assignment_actions paa1,

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''
733: AND ppa1.report_qualifier = ''DEFAULT''

Line 786: select pay_assignment_actions_s.nextval

782: l_eff_date <> l_pai_eff_date then
783:
784: dbg('Inserting action record');
785: dbg('Record ' || to_char(num) );
786: select pay_assignment_actions_s.nextval
787: into lockingactid
788: from dual;
789:
790: -- insert the action record.

Line 795: -- Update serial_number of Pay_assignment_actions with the

791: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
792:
793: dbg('Updating serial number');
794:
795: -- Update serial_number of Pay_assignment_actions with the
796: -- assignment_action_id .
797: update pay_assignment_actions
798: set serial_number = lockedactid
799: where assignment_action_id = lockingactid;

Line 797: update pay_assignment_actions

793: dbg('Updating serial number');
794:
795: -- Update serial_number of Pay_assignment_actions with the
796: -- assignment_action_id .
797: update pay_assignment_actions
798: set serial_number = lockedactid
799: where assignment_action_id = lockingactid;
800:
801: l_serial_number := l_person_id ;

Line 835: l_legal_employer_id pay_assignment_actions.tax_unit_id%type;

831: chunk in number) is
832:
833:
834: l_year number ;
835: l_legal_employer_id pay_assignment_actions.tax_unit_id%type;
836: l_org_id per_assignments_f.organization_id%type;
837: l_loc_id per_assignments_f.location_id%type;
838: l_per_id per_assignments_f.person_id%type;
839: l_curp per_people_f.national_identifier%type;