APPS.HR_DIRBAL dependencies on FND_NUMBER

Line 28: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

24: -- the effective date and assignment ID passed in
25: --
26: cursor get_latest_id is
27: SELECT
28: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
29: paa.assignment_action_id),16))
30: FROM pay_assignment_actions paa,
31: pay_payroll_actions ppa
32: WHERE

Line 268: SELECT to_date('06-04-' || to_char( fnd_number.canonical_to_number(

264: -- minus 1 if the current tax year is odd and cur tax year if the
265: -- year is even
266: --
267: CURSOR csr_start_fin_yr_odd_ytd(c_assignment_action_id in number ) is
268: SELECT to_date('06-04-' || to_char( fnd_number.canonical_to_number(
269: to_char( PTP.regular_payment_date,'YYYY'))
270: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
271: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
272: -1,-1,0) -

Line 274: fnd_number.canonical_to_number(

270: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
271: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
272: -1,-1,0) -
273: mod(
274: fnd_number.canonical_to_number(
275: to_char( PTP.regular_payment_date,'YYYY'))
276: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
277: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
278: -1,-1,0),2)

Line 293: SELECT to_date('06-04-' || to_char( fnd_number.canonical_to_number(

289: -- minus 1 if the current tax year is even and cur tax year if the
290: -- year is odd
291: --
292: CURSOR csr_start_fin_yr_even_ytd(c_assignment_action_id in number ) is
293: SELECT to_date('06-04-' || to_char( fnd_number.canonical_to_number(
294: to_char( PTP.regular_payment_date,'YYYY'))
295: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
296: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
297: -1,-1,0) -

Line 299: fnd_number.canonical_to_number(

295: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
296: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
297: -1,-1,0) -
298: mod(
299: fnd_number.canonical_to_number(
300: to_char( PTP.regular_payment_date,'YYYY'))
301: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
302: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
303: -1,0,-1),2)

Line 386: ( to_date('06-04-' || to_char( fnd_number.canonical_to_number(to_char(

382: --
383: -- Set expired date to the 6th of April next.
384: --
385: l_expired_date :=
386: ( to_date('06-04-' || to_char( fnd_number.canonical_to_number(to_char(
387: p_action_effective_date,'YYYY')) + l_year_add_no),'DD-MM-YYYY'));
388: --
389: RETURN l_expired_date;
390: --