[Home] [Help]
274: to_number(paa.serial_number)
275: FROM ff_archive_item_contexts faic,
276: ff_archive_items fai,
277: ff_database_items fdi,
278: pay_assignment_actions paa,
279: pay_payroll_actions ppa,
280: per_all_assignments_f paf,
281: pay_payroll_actions ppa1,
282: pay_us_states pus
354: paf.effective_end_date,
355: paa.assignment_action_id,
356: sum(fai1.value)
357: FROM
358: pay_assignment_actions paa, -- YREND PAA
359: pay_payroll_actions ppa, -- YREND PPA
360: per_all_assignments_f paf,
361: pay_payroll_actions ppa1,
362: ff_contexts fc1 , --for city context
501: hr_utility.trace('Person Id : '|| to_char(l_person_id));
502: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
503: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
504: IF (l_report_type = 'W2_MAG_XML') then
505: SELECT pay_assignment_actions_s.nextval
506: INTO lockingactid
507: FROM dual;
508: hr_utility.set_location(
509: 'pay_us_mmref_local_xml.create_assignement_act', 60);
683: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
684: ppa.legislative_parameters),
685: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
686: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
687: FROM pay_assignment_actions paa,
688: pay_payroll_actions ppa,
689: pay_action_interlocks pai,
690: pay_assignment_actions paa1,
691: pay_payroll_actions ppa1
686: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
687: FROM pay_assignment_actions paa,
688: pay_payroll_actions ppa,
689: pay_action_interlocks pai,
690: pay_assignment_actions paa1,
691: pay_payroll_actions ppa1
692: where ppa.payroll_action_id = paa.payroll_action_id
693: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
694: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')