DBA Data[Home] [Help]

APPS.PAY_US_BAL_UPLOAD dependencies on FND_NUMBER

Line 120: select fnd_number.canonical_to_number(SCL.segment1) tax_unit_id

116: (
117: p_assignment_id number
118: ,p_effective_date date
119: ) is
120: select fnd_number.canonical_to_number(SCL.segment1) tax_unit_id
121: from per_assignments_f ASG
122: ,hr_soft_coding_keyflex SCL
123: where ASG.assignment_id = p_assignment_id
124: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id