APPS.PAY_MX_SUA_MAG dependencies on FND_NUMBER

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

805: pai.action_information1, -- person ID
806: pai.tax_unit_id,
807: pai.effective_date,
808: nvl(pai.action_information10, 'N'), -- Do not report flag
809: fnd_number.canonical_to_number(pai.action_information8), --IDW
810: pai.action_information2, -- transaction date
811: pai.action_information24 -- Report Rehire Termination
812: FROM pay_action_information pai,
813: pay_assignment_actions paa_arch,

Line 893: SELECT fnd_number.canonical_to_number(

889: WHERE paf.assignment_id = paa.assignment_id
890: AND paa.assignment_action_id = cp_asg_act_id;
891:
892: CURSOR csr_asg_actions (cp_person_id number) IS
893: SELECT fnd_number.canonical_to_number(
894: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
895: fnd_date.canonical_to_date(g_mag_end_date)
896: FROM DUAL
897: UNION

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

913: AND ppa.report_type = 'SUA_MAG'
914: AND ppa.report_qualifier = 'SUA_MAG'
915: AND ppa.report_category = 'RT'
916: AND ppa.action_status = 'C'
917: /*AND cp_gre_id = fnd_number.canonical_to_number(
918: pay_mx_utility.get_legi_param_val('GRE',
919: ppa.legislative_parameters))
920: AND cp_curr_date > fnd_date.canonical_to_date(
921: pay_mx_utility.get_legi_param_val('END_DATE',

Line 923: AND fnd_number.canonical_to_number(g_mag_gre_id) =

919: ppa.legislative_parameters))
920: AND cp_curr_date > fnd_date.canonical_to_date(
921: pay_mx_utility.get_legi_param_val('END_DATE',
922: ppa.legislative_parameters))*/
923: AND fnd_number.canonical_to_number(g_mag_gre_id) =
924: fnd_number.canonical_to_number(
925: pay_mx_utility.get_legi_param_val('GRE',
926: ppa.legislative_parameters))
927: AND fnd_date.canonical_to_date(g_mag_end_date) >

Line 924: fnd_number.canonical_to_number(

920: AND cp_curr_date > fnd_date.canonical_to_date(
921: pay_mx_utility.get_legi_param_val('END_DATE',
922: ppa.legislative_parameters))*/
923: AND fnd_number.canonical_to_number(g_mag_gre_id) =
924: fnd_number.canonical_to_number(
925: pay_mx_utility.get_legi_param_val('GRE',
926: ppa.legislative_parameters))
927: AND fnd_date.canonical_to_date(g_mag_end_date) >
928: fnd_date.canonical_to_date(

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

930: ppa.legislative_parameters))
931: ORDER BY 2 DESC;
932:
933: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS
934: SELECT fnd_number.canonical_to_number(pai.action_information8)
935: FROM pay_payroll_actions ppa_sua,
936: pay_assignment_actions paa_sua,
937: pay_assignment_actions paa_arch,
938: pay_action_interlocks lck,

Line 952: AND fnd_number.canonical_to_number(g_mag_gre_id) =

948: AND ppa_sua.report_type = 'SUA_MAG'
949: AND ppa_sua.report_qualifier = 'SUA_MAG'
950: AND ppa_sua.report_category = 'RT'
951: AND ppa_sua.action_status = 'C'
952: AND fnd_number.canonical_to_number(g_mag_gre_id) =
953: fnd_number.canonical_to_number(
954: pay_mx_utility.get_legi_param_val('GRE',
955: ppa_sua.legislative_parameters))
956: AND fnd_date.canonical_to_date(g_mag_end_date) >

Line 953: fnd_number.canonical_to_number(

949: AND ppa_sua.report_qualifier = 'SUA_MAG'
950: AND ppa_sua.report_category = 'RT'
951: AND ppa_sua.action_status = 'C'
952: AND fnd_number.canonical_to_number(g_mag_gre_id) =
953: fnd_number.canonical_to_number(
954: pay_mx_utility.get_legi_param_val('GRE',
955: ppa_sua.legislative_parameters))
956: AND fnd_date.canonical_to_date(g_mag_end_date) >
957: fnd_date.canonical_to_date(

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

1066: FETCH csr_person INTO lv_person_id;
1067: CLOSE csr_person;
1068:
1069: lb_person_processed := FALSE;
1070: OPEN csr_asg_actions (fnd_number.canonical_to_number(lv_person_id));
1071: LOOP
1072: FETCH csr_asg_actions INTO ln_assignment_action_id,
1073: ld_effective_date;
1074:

Line 1242: fnd_number.canonical_to_number(g_mag_gre_id),

1238: END LOOP;
1239: CLOSE get_emp_trans;
1240: per_mx_ss_affiliation.process_transactions (
1241: lv_person_id,
1242: fnd_number.canonical_to_number(g_mag_gre_id),
1243: fnd_date.canonical_to_date(g_mag_end_date),
1244: 'SUA_MAG',
1245: 'SUA_MAG',
1246: 'RT',