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.PQP_US_PENSION_EXTRACTS dependencies on FND_NUMBER

Line 4947: hcf.segment1= Nvl(Fnd_Number.NUMBER_to_canonical(c_gre_id),

4943: WHERE paf.assignment_id = c_assignment_id
4944: AND paf.business_group_id = c_business_group_id
4945: AND hcf.soft_coding_keyflex_id(+) = paf.soft_coding_keyflex_id
4946: AND (c_gre_id IS NULL OR
4947: hcf.segment1= Nvl(Fnd_Number.NUMBER_to_canonical(c_gre_id),
4948: hcf.segment1)
4949: )
4950: AND (c_payroll_id IS NULL OR
4951: paf.payroll_id = c_payroll_id)

Line 4996: hcf.segment1 = Nvl(Fnd_Number.NUMBER_to_canonical(c_tax_unit_id), hcf.segment1)

4992: ,hr_soft_coding_keyflex hcf
4993: WHERE paf.assignment_id = c_assignment_id
4994: AND hcf.soft_coding_keyflex_id(+) = paf.soft_coding_keyflex_id
4995: AND (c_tax_unit_id IS NULL OR
4996: hcf.segment1 = Nvl(Fnd_Number.NUMBER_to_canonical(c_tax_unit_id), hcf.segment1)
4997: )
4998: AND (c_payroll_id IS NULL
4999: OR paf.payroll_id = Nvl(c_payroll_id,paf.payroll_id)
5000: )