APPS.PER_MX_SS_AFFILIATION dependencies on FND_NUMBER

Line 670: SELECT fnd_number.canonical_to_number(pai.action_information8)

666: P_TRANSACTIONS IN OUT NOCOPY transactions
667: ) AS
668:
669: CURSOR csr_prev_idw(cp_gre_token VARCHAR2) IS
670: SELECT fnd_number.canonical_to_number(pai.action_information8)
671: FROM pay_payroll_actions ppa_mag,
672: pay_assignment_actions paa_mag,
673: --pay_assignment_actions paa_arch,
674: pay_action_interlocks lck,

Line 689: AND p_gre_id = fnd_number.canonical_to_number(

685: AND ppa_mag.report_type = p_report_type
686: AND ppa_mag.report_qualifier = p_report_qualifier
687: AND ppa_mag.report_category = p_report_category
688: AND ppa_mag.action_status = 'C'
689: AND p_gre_id = fnd_number.canonical_to_number(
690: pay_mx_utility.get_legi_param_val(cp_gre_token,
691: ppa_mag.legislative_parameters))
692: AND p_end_date > fnd_date.canonical_to_date(
693: pay_mx_utility.get_legi_param_val('END_DATE',

Line 830: fnd_number.canonical_to_number(pai.action_information11), -- IDW

826: pai.action_information8, -- Worker Type
827: pai.action_information9, -- RWW Indicator
828: pai.action_information10, -- Hire Date
829: -- Bug 5919339
830: fnd_number.canonical_to_number(pai.action_information11), -- IDW
831: pai.action_information18 -- Salary Type
832: -- Bug 6065124
833: FROM pay_action_information pai /*,
834: pay_assignment_actions paa_arch,

Line 848: /*SELECT fnd_number.canonical_to_number(

844: decode (paf.primary_flag, 'Y', 1, 2),
845: paf.assignment_id*/;
846:
847: CURSOR csr_asg_actions (cp_person_id number) IS
848: /*SELECT fnd_number.canonical_to_number(
849: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
850: fnd_date.canonical_to_date (g_end_date)
851: FROM dual
852: UNION

Line 923: fnd_number.canonical_to_number (pai.action_information8), -- IDW

919: pai.action_information2, -- Date of Transaction
920: pai.action_information3, -- Employee SSN
921: pai.action_information4, -- Type of Transaction
922: pai.action_information5, -- Employer SS ID
923: fnd_number.canonical_to_number (pai.action_information8), -- IDW
924: pai.action_information9 -- Leaving reason
925: FROM pay_action_information pai,
926: pay_action_interlocks lck
927: WHERE lck.locking_action_id = cp_assignment_action_id

Line 1122: fnd_number.canonical_to_number(g_trans_gre_id),

1118: END IF;
1119: END LOOP;
1120: CLOSE csr_transactions;
1121: process_transactions (lv_person_id,
1122: fnd_number.canonical_to_number(g_trans_gre_id),
1123: fnd_date.canonical_to_date(g_end_date),
1124: 'MX_SS_AFFL',
1125: 'MX_SS_AFFL',
1126: 'RT',