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

Line 156: ,fnd_number.canonical_to_number(PEM_INFORMATION1) AS PEM_INFORMATION1

152:
153: CURSOR child_prev_emp (personid NUMBER, stdate DATE) IS
154: SELECT START_DATE
155: ,END_DATE
156: ,fnd_number.canonical_to_number(PEM_INFORMATION1) AS PEM_INFORMATION1
157: FROM PER_PREVIOUS_EMPLOYERS
158: WHERE person_id = personid
159: AND end_date BETWEEN TO_DATE('01/01/'|| TO_CHAR(stdate,'yyyy'), 'mm/dd/yyyy' )
160: AND stdate

Line 671: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS PT_Percent

667: BEGIN
668: SELECT PAA.ABS_INFORMATION1 AS Cert_type
669: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Cert_stdt
670: ,to_date(PAA.ABS_INFORMATION3,'yyyy/mm/dd hh24:mi:ss') AS Cert_endt
671: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS PT_Percent
672: ,to_date(PAA.ABS_INFORMATION5,'yyyy/mm/dd hh24:mi:ss') AS Follow_due
673: ,to_date(PAA.ABS_INFORMATION6,'yyyy/mm/dd hh24:mi:ss') AS Follow_created
674: ,PAA.ABS_INFORMATION7 AS reimb_ss
675: ,PAA.ABS_INFORMATION8 AS dailyrate_ss

Line 3743: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_p_compensation_rate

3739: -- Fetch EIT values from absence payment details form
3740: -- 9 segments
3741: BEGIN
3742: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_p_dob
3743: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_p_compensation_rate
3744: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_p_maternity_days
3745: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_p_pt_maternity_days
3746: ,PAA.ABS_INFORMATION5 --AS l_p_reimburse_from_ss
3747: ,PAA.ABS_INFORMATION6 --AS l_p_use_ss_daily_rate

Line 3744: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_p_maternity_days

3740: -- 9 segments
3741: BEGIN
3742: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_p_dob
3743: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_p_compensation_rate
3744: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_p_maternity_days
3745: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_p_pt_maternity_days
3746: ,PAA.ABS_INFORMATION5 --AS l_p_reimburse_from_ss
3747: ,PAA.ABS_INFORMATION6 --AS l_p_use_ss_daily_rate
3748: ,PAA.ABS_INFORMATION7 --AS l_p_reclaimable_pay_max_6g

Line 3745: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_p_pt_maternity_days

3741: BEGIN
3742: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_p_dob
3743: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_p_compensation_rate
3744: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_p_maternity_days
3745: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_p_pt_maternity_days
3746: ,PAA.ABS_INFORMATION5 --AS l_p_reimburse_from_ss
3747: ,PAA.ABS_INFORMATION6 --AS l_p_use_ss_daily_rate
3748: ,PAA.ABS_INFORMATION7 --AS l_p_reclaimable_pay_max_6g
3749: ,PAA.ABS_INFORMATION8 --AS l_p_hol_acc_ent

Line 4183: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate

4179: -- Fetch EIT values from absence payment details form
4180: -- 9 segments
4181: BEGIN
4182: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4183: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4184: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4185: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4186: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4187: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born

Line 4184: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent

4180: -- 9 segments
4181: BEGIN
4182: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4183: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4184: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4185: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4186: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4187: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4188: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss

Line 4185: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave

4181: BEGIN
4182: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4183: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4184: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4185: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4186: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4187: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4188: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss
4189: ,PAA.ABS_INFORMATION8 --AS l_ptp_use_ss_daily_rate

Line 4186: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity

4182: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4183: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4184: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4185: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4186: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4187: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4188: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss
4189: ,PAA.ABS_INFORMATION8 --AS l_ptp_use_ss_daily_rate
4190: ,PAA.ABS_INFORMATION9 --AS l_ptp_reclaimable_pay_max_6g

Line 4187: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born

4183: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4184: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4185: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4186: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4187: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4188: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss
4189: ,PAA.ABS_INFORMATION8 --AS l_ptp_use_ss_daily_rate
4190: ,PAA.ABS_INFORMATION9 --AS l_ptp_reclaimable_pay_max_6g
4191: ,PAA.ABS_INFORMATION10 --AS l_ptp_hol_acc_ent

Line 4653: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born

4649: -- 9 segments, 12 segments, now 13 segments, 14 segments, 14th not used for calc
4650: BEGIN
4651: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_m_expected_dob
4652: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_m_dob
4653: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4654: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4655: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4656: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4657: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days

Line 4654: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate

4650: BEGIN
4651: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_m_expected_dob
4652: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_m_dob
4653: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4654: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4655: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4656: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4657: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days
4658: ,PAA.ABS_INFORMATION8 --AS l_m_reimurse_from_ss

Line 4656: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days

4652: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_m_dob
4653: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4654: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4655: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4656: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4657: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days
4658: ,PAA.ABS_INFORMATION8 --AS l_m_reimurse_from_ss
4659: ,PAA.ABS_INFORMATION9 --AS l_m_use_ss_daily_rate
4660: ,PAA.ABS_INFORMATION10 --AS l_m_reclaimable_pay_max_6g

Line 4657: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days

4653: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4654: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4655: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4656: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4657: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days
4658: ,PAA.ABS_INFORMATION8 --AS l_m_reimurse_from_ss
4659: ,PAA.ABS_INFORMATION9 --AS l_m_use_ss_daily_rate
4660: ,PAA.ABS_INFORMATION10 --AS l_m_reclaimable_pay_max_6g
4661: ,PAA.ABS_INFORMATION11 --AS l_m_hol_acc_ent

Line 5117: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage

5113: -- 9 segments, 13 segments
5114: BEGIN
5115: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_expected_dob
5116: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5117: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5118: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5119: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5120: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5121: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born

Line 5118: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate

5114: BEGIN
5115: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_expected_dob
5116: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5117: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5118: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5119: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5120: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5121: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5122: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss

Line 5119: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days

5115: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_expected_dob
5116: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5117: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5118: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5119: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5120: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5121: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5122: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss
5123: ,PAA.ABS_INFORMATION9 --AS l_ptm_use_ss_daily_rate

Line 5120: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days

5116: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5117: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5118: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5119: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5120: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5121: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5122: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss
5123: ,PAA.ABS_INFORMATION9 --AS l_ptm_use_ss_daily_rate
5124: ,PAA.ABS_INFORMATION10 --AS l_ptm_reclaim_pay_max_6g

Line 5121: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born

5117: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5118: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5119: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5120: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5121: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5122: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss
5123: ,PAA.ABS_INFORMATION9 --AS l_ptm_use_ss_daily_rate
5124: ,PAA.ABS_INFORMATION10 --AS l_ptm_reclaim_pay_max_6g
5125: ,PAA.ABS_INFORMATION11 --AS l_ptm_hol_acc_ent

Line 5624: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS Comprate

5620:
5621: -- rewriting cursor for changed segments
5622: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') AS Dateofadoption
5623: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Dateofbirth
5624: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS Comprate
5625: ,PAA.ABS_INFORMATION4 AS reimb_ss
5626: ,PAA.ABS_INFORMATION5 AS Use_ss_rate
5627: ,PAA.ABS_INFORMATION6 AS restrict_ss_sl
5628: ,PAA.ABS_INFORMATION7 AS dummy

Line 5630: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION9) AS NumOfChildren

5626: ,PAA.ABS_INFORMATION5 AS Use_ss_rate
5627: ,PAA.ABS_INFORMATION6 AS restrict_ss_sl
5628: ,PAA.ABS_INFORMATION7 AS dummy
5629: ,PAA.ABS_INFORMATION8 AS Daily_rate_option
5630: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION9) AS NumOfChildren
5631: ,PAA.ABS_INFORMATION15 AS intial_absence
5632: ,PAA.ABS_INFORMATION16 AS intial_abs_attend_id
5633: INTO l_adopt_doa
5634: ,l_adopt_dob

Line 6135: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS PartTimePercent

6131: */
6132:
6133: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') AS Dateofadoption
6134: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Dateofbirth
6135: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS PartTimePercent
6136: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS Comprate
6137: ,PAA.ABS_INFORMATION5 AS reimurse_ss--Use_ss_rate
6138: ,PAA.ABS_INFORMATION6 AS use_ss_rate
6139: ,PAA.ABS_INFORMATION7 AS reclaim_6g

Line 6136: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS Comprate

6132:
6133: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') AS Dateofadoption
6134: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Dateofbirth
6135: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS PartTimePercent
6136: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS Comprate
6137: ,PAA.ABS_INFORMATION5 AS reimurse_ss--Use_ss_rate
6138: ,PAA.ABS_INFORMATION6 AS use_ss_rate
6139: ,PAA.ABS_INFORMATION7 AS reclaim_6g
6140: ,PAA.ABS_INFORMATION9 AS dailtrate

Line 6141: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION10) AS NumOfChildren

6137: ,PAA.ABS_INFORMATION5 AS reimurse_ss--Use_ss_rate
6138: ,PAA.ABS_INFORMATION6 AS use_ss_rate
6139: ,PAA.ABS_INFORMATION7 AS reclaim_6g
6140: ,PAA.ABS_INFORMATION9 AS dailtrate
6141: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION10) AS NumOfChildren
6142: ,PAA.ABS_INFORMATION15 AS intial_absence
6143: ,PAA.ABS_INFORMATION16 AS intial_abs_attend_id
6144: INTO l_adopt_doa
6145: ,l_adopt_dob

Line 6748: l_over_empr_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

6744: l_start_date := to_date(l_tab(l_cur).eevalue,'yyyy/mm/dd hh24:mi:ss') ;
6745: elsif l_tab(l_cur).eename = 'End Date' THEN
6746: l_end_date := to_date(l_tab(l_cur).eevalue,'yyyy/mm/dd hh24:mi:ss');
6747: elsif l_tab(l_cur).eename = 'Employer Period Daily Rate' THEN
6748: l_over_empr_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6749: elsif l_tab(l_cur).eename = 'Social Security Daily Rate' THEN
6750: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6751: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6752: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

Line 6750: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

6746: l_end_date := to_date(l_tab(l_cur).eevalue,'yyyy/mm/dd hh24:mi:ss');
6747: elsif l_tab(l_cur).eename = 'Employer Period Daily Rate' THEN
6748: l_over_empr_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6749: elsif l_tab(l_cur).eename = 'Social Security Daily Rate' THEN
6750: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6751: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6752: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6753: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6754: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

Line 6752: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

6748: l_over_empr_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6749: elsif l_tab(l_cur).eename = 'Social Security Daily Rate' THEN
6750: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6751: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6752: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6753: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6754: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6755: elsif l_tab(l_cur).eename = 'Social Security Period Days' THEN
6756: l_over_ss_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

Line 6754: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

6750: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6751: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6752: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6753: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6754: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6755: elsif l_tab(l_cur).eename = 'Social Security Period Days' THEN
6756: l_over_ss_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6757: elsif l_tab(l_cur).eename = 'Absence Category' THEN
6758: l_over_category := l_tab(l_cur).eevalue;

Line 6756: l_over_ss_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

6752: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6753: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6754: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6755: elsif l_tab(l_cur).eename = 'Social Security Period Days' THEN
6756: l_over_ss_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6757: elsif l_tab(l_cur).eename = 'Absence Category' THEN
6758: l_over_category := l_tab(l_cur).eevalue;
6759: end if;
6760: -- Check no. of input values of override element is 5

Line 7090: select fnd_number.canonical_to_number(GLOBAL_VALUE)

7086:
7087: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken
7088: -- from Global (NO_NATIONAL_INSURANCE_BASE_RATE) and not user table (NATIONAL_INSURANCE_BASE_RATE).
7089:
7090: select fnd_number.canonical_to_number(GLOBAL_VALUE)
7091: into l_g_rate
7092: from ff_globals_f
7093: where global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
7094: and LEGISLATION_CODE = 'NO'

Line 7457: l_creator_id_num := fnd_number.canonical_to_number(l_creator_id);

7453: OPEN csr_get_screen_value(p_element_entry_id,l_ip_value_id);
7454: FETCH csr_get_screen_value INTO l_creator_id;
7455: CLOSE csr_get_screen_value;
7456:
7457: l_creator_id_num := fnd_number.canonical_to_number(l_creator_id);
7458:
7459: OPEN csr_get_baby_dob(l_creator_id_num);
7460: FETCH csr_get_baby_dob INTO l_dob;
7461: CLOSE csr_get_baby_dob;

Line 7555: l_creator_id_num := fnd_number.canonical_to_number(l_creator_id);

7551: OPEN csr_get_screen_value(p_element_entry_id,l_ip_value_id);
7552: FETCH csr_get_screen_value INTO l_creator_id;
7553: CLOSE csr_get_screen_value;
7554:
7555: l_creator_id_num := fnd_number.canonical_to_number(l_creator_id);
7556:
7557: OPEN csr_get_baby_dob(l_creator_id_num);
7558: FETCH csr_get_baby_dob INTO l_dob;
7559: CLOSE csr_get_baby_dob;