DBA Data[Home] [Help]

APPS.PAY_US_MAGTAPE_REPORTING dependencies on HR_SOFT_CODING_KEYFLEX

Line 622: hr_soft_coding_keyflex SCL,

618: ASG.assignment_id assignment_id,
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'

Line 647: hr_soft_coding_keyflex SCL,

643: ASG.assignment_id assignment_id,
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,