DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on FND_NUMBER

Line 20: -- 17-Jan-2011 dduvvuri 115.35 Bug# 9691417 - Modified cursor in function get_leave_initialise to use fnd_number.canonical_to_number instead of to_number

16: -- 18-Jun-2012 mdubasi 115.37 Bug# 14094863 - Modified cursor c_get_initialise for considering leave initialization
17: -- when the accrual plan's start date is later and in between the seeded element start-end date
18: -- 02-Jun-2011 jmarupil 115.36 Bug# 12586038 - Modified cursor csr_get_ppl_detail for recurring paid parental leave
19: -- 25-jan-2011 jmarupil 115.35 Bug# 12586038 - Modified function get_paid_parental_leave for recurring paid parental leave
20: -- 17-Jan-2011 dduvvuri 115.35 Bug# 9691417 - Modified cursor in function get_leave_initialise to use fnd_number.canonical_to_number instead of to_number
21: -- 09-Dec-2010 avenkatk 115.34 Bug# 10384820 Modified function get_paid_parental_leave for retropay case
22: -- 24-Nov-2010 skshin 115.33 Bug #10212532 - Added get_paid_parental_leave function and made changes for paid parental leave
23: -- 16-Nov-2010 avenkatk 115.30 Bug #9950136 - Added changes for foreign workers accruals
24: -- 12-MAY-2010 skshin 115.29 9507714 - Modifed cursor c_enrollment_startdate to remove a join to cover a new primary assignment change

Line 2461: sum(nvl(fnd_number.canonical_to_number(pev1.screen_entry_value),0))

2457: ,v_initialise_type varchar2
2458: ,v_start_date date
2459: ,v_end_date date ) is
2460: select
2461: sum(nvl(fnd_number.canonical_to_number(pev1.screen_entry_value),0))
2462: from
2463: pay_accrual_plans pap
2464: ,pay_element_types_f pet
2465: ,pay_element_links_f pel