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 315: , p_action_information5 => fnd_number.number_to_canonical(csr_rec.payment_amount) -- Bug: 3604131

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

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

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

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

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

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

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

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

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

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

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

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

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