APPS.PER_MX_SS_AFFILIATION dependencies on FND_NUMBER

Line 95: vvijayku 13-Apr-2011 115.25 11906020 Added fnd_number.number_to_canonical in the cursors

91: vvijayku 19-Nov-2009 115.22 8768679 Added code to report the 08 transactions one day before the
92: date of transaction.
93: vvijayku 20-Nov-2009 115.23 8768679 Added comments about the changes made for the fix.
94: vvijayku 20-Nov-2009 115.24 8768679 Modified the comments added earlier.
95: vvijayku 13-Apr-2011 115.25 11906020 Added fnd_number.number_to_canonical in the cursors
96: which are comparing the action_information1 to cp_person_id
97: jeisaac 28-Aug-2012 115.26 14325500 Modified procedure process_transactions to filter transactions
98: for SUA when seniority changes but IDW does not change
99: ***************************************************************************/

Line 777: SELECT nvl(fnd_number.canonical_to_number(pai.action_information8),-1)

773: P_TRANSACTIONS IN OUT NOCOPY transactions
774: ) AS
775:
776: CURSOR csr_prev_idw(cp_gre_token VARCHAR2) IS
777: SELECT nvl(fnd_number.canonical_to_number(pai.action_information8),-1)
778: FROM pay_payroll_actions ppa_mag,
779: pay_assignment_actions paa_mag,
780: --pay_assignment_actions paa_arch,
781: pay_action_interlocks lck,

Line 789: AND pai.action_information1 = fnd_number.number_to_canonical(p_person_id)

785: /*AND lck.locked_action_id = paa_arch.assignment_action_id
786: AND paa_arch.assignment_action_id = pai.action_context_id*/
787: AND lck.locked_action_id = pai.action_context_id
788: AND pai.action_information_category = 'MX SS TRANSACTIONS'
789: AND pai.action_information1 = fnd_number.number_to_canonical(p_person_id)
790: AND pai.action_information4 IN ('07','08')
791: AND ppa_mag.action_type = 'X'
792: AND ppa_mag.report_type = p_report_type
793: AND ppa_mag.report_qualifier = p_report_qualifier

Line 796: AND p_gre_id = fnd_number.canonical_to_number(

792: AND ppa_mag.report_type = p_report_type
793: AND ppa_mag.report_qualifier = p_report_qualifier
794: AND ppa_mag.report_category = p_report_category
795: AND ppa_mag.action_status = 'C'
796: AND p_gre_id = fnd_number.canonical_to_number(
797: pay_mx_utility.get_legi_param_val(cp_gre_token,
798: ppa_mag.legislative_parameters))
799: AND p_end_date > fnd_date.canonical_to_date(
800: pay_mx_utility.get_legi_param_val('END_DATE',

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

976: pai.action_information8, -- Worker Type
977: pai.action_information9, -- RWW Indicator
978: pai.action_information10, -- Hire Date
979: -- Bug 5919339
980: fnd_number.canonical_to_number(pai.action_information11), -- IDW
981: pai.action_information18 -- Salary Type
982: -- Bug 6065124
983: FROM pay_action_information pai /*,
984: pay_assignment_actions paa_arch,

Line 990: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)

986: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
987: /*and lck.locking_action_id = cp_assignment_action_id
988: AND lck.locked_action_id = pai.action_context_id*/
989: AND pai.action_context_type = 'AAP'
990: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)
991: AND nvl(pai.action_information21, 'N') <> 'Y' -- Do not report flag
992: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
993: ORDER BY pai.effective_date DESC/*,
994: decode (paf.primary_flag, 'Y', 1, 2),

Line 998: /*SELECT fnd_number.canonical_to_number(

994: decode (paf.primary_flag, 'Y', 1, 2),
995: paf.assignment_id*/;
996:
997: CURSOR csr_asg_actions (cp_person_id number) IS
998: /*SELECT fnd_number.canonical_to_number(
999: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
1000: fnd_date.canonical_to_date (g_end_date)
1001: FROM dual
1002: UNION

Line 1015: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)

1011: WHERE paa.payroll_action_id = ppa.payroll_action_id
1012: AND paa.assignment_action_id = lck.locking_action_id
1013: AND pai.action_context_id = lck.locked_action_id
1014: AND pai.action_information_category = 'MX SS PERSON INFORMATION'
1015: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)
1016: AND ppa.report_type = 'MX_SS_AFFL'
1017: AND ppa.report_qualifier = 'MX_SS_AFFL'
1018: AND ppa.report_category = 'RT'
1019: AND ppa.action_status = 'C'

Line 1034: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)

1030: SELECT pai.action_context_id,
1031: pai.effective_date
1032: FROM pay_action_information pai
1033: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
1034: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)
1035: -- Bug 6060070
1036: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
1037: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1038: fnd_date.canonical_to_date (pai.action_information2),

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

1071: pai.action_information2, -- Date of Transaction
1072: pai.action_information3, -- Employee SSN
1073: pai.action_information4, -- Type of Transaction
1074: pai.action_information5, -- Employer SS ID
1075: fnd_number.canonical_to_number (pai.action_information8), -- IDW
1076: pai.action_information9, -- Leaving reason
1077: pai.action_information24 -- Reporting option (YES/NO)
1078: FROM pay_action_information pai,
1079: pay_action_interlocks lck

Line 1240: ln_person_id := fnd_number.canonical_to_number(lv_person_id);

1236: ln_idw,
1237: lv_salary_type;
1238: CLOSE get_emp_details;
1239:
1240: ln_person_id := fnd_number.canonical_to_number(lv_person_id);
1241:
1242: /*END LOOP;
1243: CLOSE csr_asg_actions;*/
1244:

Line 1297: fnd_number.canonical_to_number(g_trans_gre_id),

1293: END IF;
1294: END LOOP;
1295: CLOSE csr_transactions;
1296: process_transactions (lv_person_id,
1297: fnd_number.canonical_to_number(g_trans_gre_id),
1298: fnd_date.canonical_to_date(g_end_date),
1299: 'MX_SS_AFFL',
1300: 'MX_SS_AFFL',
1301: 'RT',