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 PER_ASSIGNMENTS_F

Line 112: l_org_id per_assignments_f.organization_id%type;

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;
116: l_asg_set_id number;

Line 113: l_loc_id per_assignments_f.location_id%type;

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;
116: l_asg_set_id number;
117: l_effective_date date;

Line 114: l_per_id per_assignments_f.person_id%type;

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;
116: l_asg_set_id number;
117: l_effective_date date;
118:

Line 360: per_assignments_f paf,

356: paa_arch.assignment_action_id,
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

Line 378: from per_assignments_f paf2

374: between paf.effective_start_date and paf.effective_end_date
375: AND paf.location_id = ' || p_loc_id || '
376: AND paf.effective_start_date =
377: (select max(paf2.effective_start_date)
378: from per_assignments_f paf2
379: where paf2.assignment_id = paf.assignment_id
380: and paf2.effective_start_date <= ''' || p_effective_date || ''')
381: AND paf.effective_end_date >= ppa_arch.start_date
382: AND paf.assignment_type = ''E''

Line 415: per_assignments_f paf,

411: paa_arch.assignment_action_id,
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''

Line 432: from per_assignments_f paf2

428: between paf.effective_start_date and paf.effective_end_date
429: AND paf.location_id = ' || p_loc_id || '
430: AND paf.effective_start_date =
431: (select max(paf2.effective_start_date)
432: from per_assignments_f paf2
433: where paf2.assignment_id = paf.assignment_id
434: and paf2.effective_start_date <= ''' || p_effective_date || ''')
435: AND paf.effective_end_date >= ppa_arch.start_date
436: AND paf.assignment_type = ''E''

Line 479: per_assignments_f paf,

475: paa_arch.assignment_action_id,
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

Line 497: from per_assignments_f paf2

493: between paf.effective_start_date and paf.effective_end_date
494: AND paf.organization_id = ' || p_org_id || '
495: AND paf.effective_start_date =
496: (select max(paf2.effective_start_date)
497: from per_assignments_f paf2
498: where paf2.assignment_id = paf.assignment_id
499: and paf2.effective_start_date <= ''' || p_effective_date || ''')
500: AND paf.effective_end_date >= ppa_arch.start_date
501: AND paf.assignment_type = ''E''

Line 535: per_assignments_f paf,

531: paa_arch.assignment_action_id,
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''

Line 552: from per_assignments_f paf2

548: between paf.effective_start_date and paf.effective_end_date
549: AND paf.location_id = ' || p_org_id || '
550: AND paf.effective_start_date =
551: (select max(paf2.effective_start_date)
552: from per_assignments_f paf2
553: where paf2.assignment_id = paf.assignment_id
554: and paf2.effective_start_date <= ''' || p_effective_date || ''')
555: AND paf.effective_end_date >= ppa_arch.start_date
556: AND paf.assignment_type = ''E''

Line 594: FROM per_assignments_f paf,

590: pai.effective_date,
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''

Line 609: from per_assignments_f paf2

605: AND paa_arch.assignment_id = paf.assignment_id
606: AND paf.PERSON_ID = ' || p_per_id || '
607: AND paa_arch.assignment_id = paf.assignment_id
608: AND paf.effective_start_date = (select max(paf2.effective_start_date)
609: from per_assignments_f paf2
610: where paf2.assignment_id = paf.assignment_id
611: and paf2.effective_start_date <= ''' || p_effective_date || ''')
612: AND paf.effective_end_date >= ppa_arch.start_date
613: AND paf.assignment_type = ''E''

Line 651: FROM per_assignments_f paf,

647: pai.effective_date,
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

Line 665: from per_assignments_f paf2

661: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
662: AND paa_arch.action_status =''C''
663: AND paa_arch.assignment_id = paf.assignment_id
664: AND paf.effective_start_date = (select max(paf2.effective_start_date)
665: from per_assignments_f paf2
666: where paf2.assignment_id = paf.assignment_id
667: and paf2.effective_start_date <= ''' || p_effective_date || ''')
668: AND paf.effective_end_date >= ppa_arch.start_date
669: AND paf.assignment_type = ''E''

Line 705: FROM per_assignments_f paf,

701: pai.effective_date,
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''

Line 718: from per_assignments_f paf2

714: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
715: AND paa_arch.action_status =''C''
716: AND paa_arch.assignment_id = paf.assignment_id
717: AND paf.effective_start_date = (select max(paf2.effective_start_date)
718: from per_assignments_f paf2
719: where paf2.assignment_id = paf.assignment_id
720: and paf2.effective_start_date <= ''' || p_effective_date || ''')
721: AND paf.effective_end_date >= ppa_arch.start_date
722: AND paf.assignment_type = ''E''

Line 836: l_org_id per_assignments_f.organization_id%type;

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;
840: l_asg_set_id number;

Line 837: l_loc_id per_assignments_f.location_id%type;

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;
840: l_asg_set_id number;
841: l_effective_date date;

Line 838: l_per_id per_assignments_f.person_id%type;

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;
840: l_asg_set_id number;
841: l_effective_date date;
842: l_report_type pay_payroll_actions.report_type%TYPE;