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_GB_RTI_P60 dependencies on FND_NUMBER

Line 579: fnd_number.canonical_to_number(prrv.result_value),NULL)))

575: IS
576: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
577: MAX(DECODE(name,'Tax Basis',prrv.result_value,NULL)),
578: to_number(max(decode(name,'Pay Previous',
579: fnd_number.canonical_to_number(prrv.result_value),NULL)))
580: pay_previous,
581: to_number(max(decode(name,'Tax Previous',
582: fnd_number.canonical_to_number(prrv.result_value),NULL)))
583: tax_previous

Line 582: fnd_number.canonical_to_number(prrv.result_value),NULL)))

578: to_number(max(decode(name,'Pay Previous',
579: fnd_number.canonical_to_number(prrv.result_value),NULL)))
580: pay_previous,
581: to_number(max(decode(name,'Tax Previous',
582: fnd_number.canonical_to_number(prrv.result_value),NULL)))
583: tax_previous
584: FROM pay_run_results prr ,
585: pay_run_result_values prrv ,
586: pay_input_values_f pivf

Line 596: fnd_number.canonical_to_number(screen_entry_value),NULL))

592: CURSOR csr_paye_details(p_assignment_id NUMBER) IS
593: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
594: max(decode(iv.name,'Tax Basis',screen_entry_value,NULL)) tax_basis,
595: max(decode(iv.name,'Pay Previous',
596: fnd_number.canonical_to_number(screen_entry_value),NULL))
597: pay_previous,
598: max(decode(iv.name,'Tax Previous',
599: fnd_number.canonical_to_number(screen_entry_value),NULL))
600: tax_previous

Line 599: fnd_number.canonical_to_number(screen_entry_value),NULL))

595: max(decode(iv.name,'Pay Previous',
596: fnd_number.canonical_to_number(screen_entry_value),NULL))
597: pay_previous,
598: max(decode(iv.name,'Tax Previous',
599: fnd_number.canonical_to_number(screen_entry_value),NULL))
600: tax_previous
601: FROM pay_element_entries_f e,
602: pay_element_entry_values_f v,
603: pay_input_values_f iv,

Line 3648: fnd_number.number_to_canonical(pact.request_id) request_id,

3644: CURSOR csr_payroll_details(pactid NUMBER)
3645: IS
3646: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
3647: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
3648: fnd_number.number_to_canonical(pact.request_id) request_id,
3649: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
3650: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
3651: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
3652: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

Line 4485: fnd_number.number_to_canonical(pact.request_id) request_id,

4481: CURSOR csr_payroll_details(pactid NUMBER)
4482: IS
4483: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
4484: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
4485: fnd_number.number_to_canonical(pact.request_id) request_id,
4486: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
4487: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
4488: lpad(SUBSTR(hoi.ORG_INFORMATION1,0,instr(hoi.ORG_INFORMATION1,'/')-1),3,0) tax_office_no,
4489: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

Line 4535: fnd_number.number_to_canonical(request_id) control_id,

4531:
4532: CURSOR csr_leg_param
4533: IS
4534: SELECT legislative_parameters para,
4535: fnd_number.number_to_canonical(request_id) control_id,
4536: report_type,
4537: business_group_id
4538: FROM pay_payroll_actions pact
4539: WHERE payroll_action_id = pactid;