APPS.PAY_US_MAGTAPE_REPORTING dependencies on FND_NUMBER

Line 55: select fnd_number.canonical_to_number(UE.creator_id)

51: --
52: -- Get the defined_balance_id for the specified balance DB item.
53: --
54: cursor csr_defined_balance is
55: select fnd_number.canonical_to_number(UE.creator_id)
56: from ff_database_items DI,
57: ff_user_entities UE
58: where DI.user_name = p_db_item_name
59: and UE.user_entity_id = DI.user_entity_id

Line 619: fnd_number.canonical_to_number(SCL.segment1) tax_unit_id,

615: --
616: CURSOR c_federal IS
617: SELECT ASG.person_id person_id,
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,

Line 630: AND fnd_number.canonical_to_number(SCL.segment1) = TUV.tax_unit_id

626: AND ASG.assignment_type = 'E'
627: AND ASG.effective_start_date <= l_period_end
628: AND ASG.effective_end_date >= l_period_start
629: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
630: AND fnd_number.canonical_to_number(SCL.segment1) = TUV.tax_unit_id
631: AND TUV.US_1099R_TRANSMITTER_CODE IS NULL
632: AND PPY.payroll_id = ASG.payroll_id
633: AND l_state = l_state
634: GROUP BY ASG.person_id,

Line 636: fnd_number.canonical_to_number(SCL.segment1)

632: AND PPY.payroll_id = ASG.payroll_id
633: AND l_state = l_state
634: GROUP BY ASG.person_id,
635: ASG.assignment_id,
636: fnd_number.canonical_to_number(SCL.segment1)
637: ORDER BY 1, 3, 4 DESC, 2;
638: --
639: -- People list for State W2 - State grouped within GRE.
640: --

Line 644: fnd_number.canonical_to_number(SCL.segment1) tax_unit_id,

640: --
641: CURSOR c_state IS
642: SELECT ASG.person_id person_id,
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,

Line 659: AND fnd_number.canonical_to_number(SCL.segment1) = TUV.tax_unit_id

655: AND ASG.assignment_type = 'E'
656: AND ASG.effective_start_date <= l_period_end
657: AND ASG.effective_end_date >= l_period_start
658: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
659: AND fnd_number.canonical_to_number(SCL.segment1) = TUV.tax_unit_id
660: AND TUV.US_1099R_TRANSMITTER_CODE IS NULL
661: AND PPY.payroll_id = ASG.payroll_id
662: AND SR.state_code = l_state
663: AND ET.element_name = 'VERTEX'

Line 682: fnd_number.canonical_to_number(SCL.segment1)

678: AND EE.effective_start_date <= l_period_end
679: AND EE.effective_end_date >= l_period_start)
680: GROUP BY ASG.person_id,
681: ASG.assignment_id,
682: fnd_number.canonical_to_number(SCL.segment1)
683: ORDER BY 1, 3, 4 DESC, 2;
684: --
685: --
686: --