eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_EXT dependencies on FND_NUMBER

Line 1012: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer

1008: )
1009: IS
1010: --
1011: SELECT pap.per_information8 exp_indicator
1012: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1013: FROM per_all_assignments_f paa
1014: ,per_all_people_f pap
1015: ,hr_soft_coding_keyflex hsck
1016: WHERE paa.assignment_id = p_assignment_id

Line 1242: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer

1238: )
1239: IS
1240: --
1241: SELECT pap.per_information8 exp_indicator
1242: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1243: FROM per_all_assignments_f paa
1244: ,per_all_people_f pap
1245: ,hr_soft_coding_keyflex hsck
1246: WHERE paa.assignment_id = p_assignment_id

Line 1547: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer

1543: )
1544: IS
1545: --
1546: SELECT pap.per_information8 exp_indicator
1547: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1548: FROM per_all_assignments_f paa
1549: ,per_all_people_f pap
1550: ,hr_soft_coding_keyflex hsck
1551: WHERE paa.assignment_id = p_assignment_id