APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 279: pay_assignment_actions paa,

275: to_number(paa.serial_number)
276: FROM ff_archive_item_contexts faic,
277: ff_archive_items fai,
278: ff_database_items fdi,
279: pay_assignment_actions paa,
280: pay_payroll_actions ppa,
281: per_all_assignments_f paf,
282: pay_payroll_actions ppa1,
283: pay_us_states pus

Line 359: pay_assignment_actions paa, -- YREND PAA

355: paf.effective_end_date,
356: paa.assignment_action_id,
357: sum(fai1.value)
358: FROM
359: pay_assignment_actions paa, -- YREND PAA
360: pay_payroll_actions ppa, -- YREND PPA
361: per_all_assignments_f paf,
362: pay_payroll_actions ppa1,
363: ff_contexts fc1 , --for city context

Line 423: pay_assignment_actions paa, -- YREND PAA

419: paf.effective_end_date,
420: paa.assignment_action_id,
421: sum(fai1.value)
422: FROM
423: pay_assignment_actions paa, -- YREND PAA
424: pay_payroll_actions ppa, -- YREND PPA
425: per_all_assignments_f paf,
426: pay_payroll_actions ppa1,
427: ff_contexts fc1 , --for city context

Line 568: SELECT pay_assignment_actions_s.nextval

564: hr_utility.trace('Person Id : '|| to_char(l_person_id));
565: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
567: IF (l_report_type = 'W2_MAG_XML') then
568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid
570: FROM dual;
571: hr_utility.set_location(
572: 'pay_us_mmref_local_xml.create_assignement_act', 60);

Line 750: FROM pay_assignment_actions paa,

746: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
747: ppa.legislative_parameters),
748: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
749: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
750: FROM pay_assignment_actions paa,
751: pay_payroll_actions ppa,
752: pay_action_interlocks pai,
753: pay_assignment_actions paa1,
754: pay_payroll_actions ppa1

Line 753: pay_assignment_actions paa1,

749: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
750: FROM pay_assignment_actions paa,
751: pay_payroll_actions ppa,
752: pay_action_interlocks pai,
753: pay_assignment_actions paa1,
754: pay_payroll_actions ppa1
755: where ppa.payroll_action_id = paa.payroll_action_id
756: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
757: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')