DBA Data[Home] [Help]

APPS.PAY_US_MAGTAPE_REPORTING dependencies on HR_TAX_UNITS_V

Line 623: hr_tax_units_v TUV,

619: fnd_number.canonical_to_number(SCL.segment1) tax_unit_id,
620: max(ASG.effective_end_date) effective_end_date
621: FROM per_assignments_f ASG,
622: hr_soft_coding_keyflex SCL,
623: hr_tax_units_v TUV,
624: pay_payrolls_f PPY
625: WHERE ASG.business_group_id = l_bus_group_id
626: AND ASG.assignment_type = 'E'
627: AND ASG.effective_start_date <= l_period_end

Line 648: hr_tax_units_v TUV,

644: fnd_number.canonical_to_number(SCL.segment1) tax_unit_id,
645: max(ASG.effective_end_date) effective_end_date
646: FROM per_assignments_f ASG,
647: hr_soft_coding_keyflex SCL,
648: hr_tax_units_v TUV,
649: pay_payrolls_f PPY,
650: pay_state_rules SR,
651: pay_element_types_f ET,
652: pay_input_values_f IV,