APPS.PAY_MX_SUA_MAG dependencies on FND_NUMBER

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

694: pai.action_information1, -- person ID
695: pai.tax_unit_id,
696: pai.effective_date,
697: nvl(pai.action_information10, 'N'), -- Do not report flag
698: fnd_number.canonical_to_number(pai.action_information8), --IDW
699: pai.action_information2 -- transaction date
700: FROM pay_action_information pai,
701: pay_assignment_actions paa_arch,
702: per_all_assignments_f paf,

Line 778: SELECT fnd_number.canonical_to_number(

774: WHERE paf.assignment_id = paa.assignment_id
775: AND paa.assignment_action_id = cp_asg_act_id;
776:
777: CURSOR csr_asg_actions (cp_person_id number) IS
778: SELECT fnd_number.canonical_to_number(
779: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
780: fnd_date.canonical_to_date(g_mag_end_date)
781: FROM DUAL
782: UNION

Line 802: /*AND cp_gre_id = fnd_number.canonical_to_number(

798: AND ppa.report_type = 'SUA_MAG'
799: AND ppa.report_qualifier = 'SUA_MAG'
800: AND ppa.report_category = 'RT'
801: AND ppa.action_status = 'C'
802: /*AND cp_gre_id = fnd_number.canonical_to_number(
803: pay_mx_utility.get_legi_param_val('GRE',
804: ppa.legislative_parameters))
805: AND cp_curr_date > fnd_date.canonical_to_date(
806: pay_mx_utility.get_legi_param_val('END_DATE',

Line 808: AND fnd_number.canonical_to_number(g_mag_gre_id) =

804: ppa.legislative_parameters))
805: AND cp_curr_date > fnd_date.canonical_to_date(
806: pay_mx_utility.get_legi_param_val('END_DATE',
807: ppa.legislative_parameters))*/
808: AND fnd_number.canonical_to_number(g_mag_gre_id) =
809: fnd_number.canonical_to_number(
810: pay_mx_utility.get_legi_param_val('GRE',
811: ppa.legislative_parameters))
812: AND fnd_date.canonical_to_date(g_mag_end_date) >

Line 809: fnd_number.canonical_to_number(

805: AND cp_curr_date > fnd_date.canonical_to_date(
806: pay_mx_utility.get_legi_param_val('END_DATE',
807: ppa.legislative_parameters))*/
808: AND fnd_number.canonical_to_number(g_mag_gre_id) =
809: fnd_number.canonical_to_number(
810: pay_mx_utility.get_legi_param_val('GRE',
811: ppa.legislative_parameters))
812: AND fnd_date.canonical_to_date(g_mag_end_date) >
813: fnd_date.canonical_to_date(

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

815: ppa.legislative_parameters))
816: ORDER BY 2 DESC;
817:
818: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS
819: SELECT fnd_number.canonical_to_number(pai.action_information8)
820: FROM pay_payroll_actions ppa_sua,
821: pay_assignment_actions paa_sua,
822: pay_assignment_actions paa_arch,
823: pay_action_interlocks lck,

Line 837: AND fnd_number.canonical_to_number(g_mag_gre_id) =

833: AND ppa_sua.report_type = 'SUA_MAG'
834: AND ppa_sua.report_qualifier = 'SUA_MAG'
835: AND ppa_sua.report_category = 'RT'
836: AND ppa_sua.action_status = 'C'
837: AND fnd_number.canonical_to_number(g_mag_gre_id) =
838: fnd_number.canonical_to_number(
839: pay_mx_utility.get_legi_param_val('GRE',
840: ppa_sua.legislative_parameters))
841: AND fnd_date.canonical_to_date(g_mag_end_date) >

Line 838: fnd_number.canonical_to_number(

834: AND ppa_sua.report_qualifier = 'SUA_MAG'
835: AND ppa_sua.report_category = 'RT'
836: AND ppa_sua.action_status = 'C'
837: AND fnd_number.canonical_to_number(g_mag_gre_id) =
838: fnd_number.canonical_to_number(
839: pay_mx_utility.get_legi_param_val('GRE',
840: ppa_sua.legislative_parameters))
841: AND fnd_date.canonical_to_date(g_mag_end_date) >
842: fnd_date.canonical_to_date(

Line 947: OPEN csr_asg_actions (fnd_number.canonical_to_number(lv_person_id));

943: FETCH csr_person INTO lv_person_id;
944: CLOSE csr_person;
945:
946: lb_person_processed := FALSE;
947: OPEN csr_asg_actions (fnd_number.canonical_to_number(lv_person_id));
948: LOOP
949: FETCH csr_asg_actions INTO ln_assignment_action_id,
950: ld_effective_date;
951:

Line 1114: fnd_number.canonical_to_number(g_mag_gre_id),

1110: END LOOP;
1111: CLOSE get_emp_trans;
1112: per_mx_ss_affiliation.process_transactions (
1113: lv_person_id,
1114: fnd_number.canonical_to_number(g_mag_gre_id),
1115: fnd_date.canonical_to_date(g_mag_end_date),
1116: 'SUA_MAG',
1117: 'SUA_MAG',
1118: 'RT',