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

Line 160: SELECT fnd_number.canonical_to_number(hoi.org_information20) scheme_id,

156: -- business_group_id
157:
158: CURSOR csr_scheme_names(c_business_group_id IN NUMBER)
159: IS
160: SELECT fnd_number.canonical_to_number(hoi.org_information20) scheme_id,
161: hoi.org_information2 scheme_name
162: from hr_organization_units hou,
163: hr_organization_information hoi
164: where hoi.org_information_context = 'HK_MPF_SCHEMES'

Line 174: SELECT fnd_number.canonical_to_number(prrv.result_value)

170:
171: CURSOR csr_result_value(c_run_result_id in NUMBER,
172: c_assignment_action_id IN NUMBER)
173: IS
174: SELECT fnd_number.canonical_to_number(prrv.result_value)
175: FROM pay_assignment_actions paa,
176: pay_run_results prr,
177: pay_run_result_values prrv,
178: pay_input_values_f pivf

Line 316: , p_action_information5 => fnd_number.number_to_canonical(csr_rec.payment_amount) -- Bug: 3604131

312: , p_action_information1 => csr_rec.element_reporting_name
313: , p_action_information2 => NULL
314: , p_action_information3 => NULL
315: , p_action_information4 => csr_rec.classification_name
316: , p_action_information5 => fnd_number.number_to_canonical(csr_rec.payment_amount) -- Bug: 3604131
317: , p_action_information11 => fnd_number.number_to_canonical(csr_rec.assessed_ri) -- Bug: 3604131
318: , p_action_information13 => csr_rec.period_start_date
319: , p_action_information14 => csr_rec.period_end_date);
320:

Line 317: , p_action_information11 => fnd_number.number_to_canonical(csr_rec.assessed_ri) -- Bug: 3604131

313: , p_action_information2 => NULL
314: , p_action_information3 => NULL
315: , p_action_information4 => csr_rec.classification_name
316: , p_action_information5 => fnd_number.number_to_canonical(csr_rec.payment_amount) -- Bug: 3604131
317: , p_action_information11 => fnd_number.number_to_canonical(csr_rec.assessed_ri) -- Bug: 3604131
318: , p_action_information13 => csr_rec.period_start_date
319: , p_action_information14 => csr_rec.period_end_date);
320:
321: else

Line 335: , p_action_information4 => fnd_number.number_to_canonical(csr_rec.payment_amount) -- Bug: 3604131

331: , p_action_information_category => 'APAC BALANCES 2'
332: , p_action_information1 => csr_rec.element_reporting_name
333: , p_action_information2 => NULL
334: , p_action_information3 => NULL
335: , p_action_information4 => fnd_number.number_to_canonical(csr_rec.payment_amount) -- Bug: 3604131
336: , p_action_information6 => csr_rec.period_start_date
337: , p_action_information7 => csr_rec.period_end_date
338: , p_action_information8 => fnd_number.number_to_canonical(csr_rec.assessed_ri)); -- Bug: 3604131
339:

Line 338: , p_action_information8 => fnd_number.number_to_canonical(csr_rec.assessed_ri)); -- Bug: 3604131

334: , p_action_information3 => NULL
335: , p_action_information4 => fnd_number.number_to_canonical(csr_rec.payment_amount) -- Bug: 3604131
336: , p_action_information6 => csr_rec.period_start_date
337: , p_action_information7 => csr_rec.period_end_date
338: , p_action_information8 => fnd_number.number_to_canonical(csr_rec.assessed_ri)); -- Bug: 3604131
339:
340: end if;
341:
342:

Line 398: , p_action_information4 => fnd_number.number_to_canonical(p_ytd) -- Bug: 3604131

394: , p_action_information_category => 'APAC BALANCES'
395: , p_action_information1 => p_narrative
396: , p_action_information2 => NULL
397: , p_action_information3 => NULL
398: , p_action_information4 => fnd_number.number_to_canonical(p_ytd) -- Bug: 3604131
399: , p_action_information5 => fnd_number.number_to_canonical(p_curr) -- Bug: 3604131
400: );
401:
402:

Line 399: , p_action_information5 => fnd_number.number_to_canonical(p_curr) -- Bug: 3604131

395: , p_action_information1 => p_narrative
396: , p_action_information2 => NULL
397: , p_action_information3 => NULL
398: , p_action_information4 => fnd_number.number_to_canonical(p_ytd) -- Bug: 3604131
399: , p_action_information5 => fnd_number.number_to_canonical(p_curr) -- Bug: 3604131
400: );
401:
402:
403: EXCEPTION

Line 943: , p_action_information4 => fnd_number.number_to_canonical(l_net_entitlement) -- Bug: 3604131

939: , p_source_text => NULL
940: , p_action_information_category => 'APAC ACCRUALS'
941: , p_action_information1 => l_accrual_plan_name
942: , p_action_information2 => l_accrual_category
943: , p_action_information4 => fnd_number.number_to_canonical(l_net_entitlement) -- Bug: 3604131
944: , p_action_information5 => l_accrual_uom
945: );
946:
947: END IF;