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 698: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS PT_Percent

694: BEGIN
695: SELECT PAA.ABS_INFORMATION1 AS Cert_type
696: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Cert_stdt
697: ,to_date(PAA.ABS_INFORMATION3,'yyyy/mm/dd hh24:mi:ss') AS Cert_endt
698: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS PT_Percent
699: ,to_date(PAA.ABS_INFORMATION5,'yyyy/mm/dd hh24:mi:ss') AS Follow_due
700: ,to_date(PAA.ABS_INFORMATION6,'yyyy/mm/dd hh24:mi:ss') AS Follow_created
701: ,PAA.ABS_INFORMATION7 AS reimb_ss
702: ,PAA.ABS_INFORMATION8 AS dailyrate_ss

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

3819: -- Fetch EIT values from absence payment details form
3820: -- 9 segments
3821: BEGIN
3822: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_p_dob
3823: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_p_compensation_rate
3824: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_p_maternity_days
3825: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_p_pt_maternity_days
3826: ,PAA.ABS_INFORMATION5 --AS l_p_reimburse_from_ss
3827: ,PAA.ABS_INFORMATION6 --AS l_p_use_ss_daily_rate

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

3820: -- 9 segments
3821: BEGIN
3822: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_p_dob
3823: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_p_compensation_rate
3824: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_p_maternity_days
3825: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_p_pt_maternity_days
3826: ,PAA.ABS_INFORMATION5 --AS l_p_reimburse_from_ss
3827: ,PAA.ABS_INFORMATION6 --AS l_p_use_ss_daily_rate
3828: ,PAA.ABS_INFORMATION7 --AS l_p_reclaimable_pay_max_6g

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

3821: BEGIN
3822: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_p_dob
3823: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_p_compensation_rate
3824: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_p_maternity_days
3825: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_p_pt_maternity_days
3826: ,PAA.ABS_INFORMATION5 --AS l_p_reimburse_from_ss
3827: ,PAA.ABS_INFORMATION6 --AS l_p_use_ss_daily_rate
3828: ,PAA.ABS_INFORMATION7 --AS l_p_reclaimable_pay_max_6g
3829: ,PAA.ABS_INFORMATION8 --AS l_p_hol_acc_ent

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

4260: -- Fetch EIT values from absence payment details form
4261: -- 9 segments
4262: BEGIN
4263: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4264: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4265: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4266: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4267: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4268: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born

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

4261: -- 9 segments
4262: BEGIN
4263: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4264: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4265: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4266: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4267: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4268: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4269: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss

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

4262: BEGIN
4263: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4264: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4265: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4266: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4267: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4268: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4269: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss
4270: ,PAA.ABS_INFORMATION8 --AS l_ptp_use_ss_daily_rate

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

4263: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptp_dob
4264: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4265: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4266: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4267: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4268: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4269: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss
4270: ,PAA.ABS_INFORMATION8 --AS l_ptp_use_ss_daily_rate
4271: ,PAA.ABS_INFORMATION9 --AS l_ptp_reclaimable_pay_max_6g

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

4264: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION2) --AS l_ptp_mat_compensation_rate
4265: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptp_paternity_percent
4266: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptp_days_spouse_mat_leave
4267: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptp_days_pt_maternity
4268: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptp_no_of_babies_born
4269: ,PAA.ABS_INFORMATION7 --AS l_ptp_reimburse_from_ss
4270: ,PAA.ABS_INFORMATION8 --AS l_ptp_use_ss_daily_rate
4271: ,PAA.ABS_INFORMATION9 --AS l_ptp_reclaimable_pay_max_6g
4272: ,PAA.ABS_INFORMATION10 --AS l_ptp_hol_acc_ent

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

4731: -- 9 segments, 12 segments, now 13 segments, 14 segments, 14th not used for calc
4732: BEGIN
4733: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_m_expected_dob
4734: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_m_dob
4735: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4736: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4737: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4738: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4739: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days

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

4732: BEGIN
4733: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_m_expected_dob
4734: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_m_dob
4735: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4736: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4737: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4738: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4739: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days
4740: ,PAA.ABS_INFORMATION8 --AS l_m_reimurse_from_ss

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

4734: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_m_dob
4735: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4736: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4737: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4738: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4739: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days
4740: ,PAA.ABS_INFORMATION8 --AS l_m_reimurse_from_ss
4741: ,PAA.ABS_INFORMATION9 --AS l_m_use_ss_daily_rate
4742: ,PAA.ABS_INFORMATION10 --AS l_m_reclaimable_pay_max_6g

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

4735: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_m_no_of_babies_born
4736: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_m_compensation_rate
4737: ,PAA.ABS_INFORMATION5 --AS l_m_spouse
4738: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_m_paternity_days
4739: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_m_pt_paternity_days
4740: ,PAA.ABS_INFORMATION8 --AS l_m_reimurse_from_ss
4741: ,PAA.ABS_INFORMATION9 --AS l_m_use_ss_daily_rate
4742: ,PAA.ABS_INFORMATION10 --AS l_m_reclaimable_pay_max_6g
4743: ,PAA.ABS_INFORMATION11 --AS l_m_hol_acc_ent

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

5196: -- 9 segments, 13 segments
5197: BEGIN
5198: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_expected_dob
5199: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5200: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5201: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5202: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5203: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5204: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born

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

5197: BEGIN
5198: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_expected_dob
5199: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5200: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5201: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5202: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5203: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5204: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5205: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss

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

5198: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_expected_dob
5199: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5200: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5201: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5202: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5203: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5204: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5205: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss
5206: ,PAA.ABS_INFORMATION9 --AS l_ptm_use_ss_daily_rate

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

5199: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') --AS l_ptm_dob
5200: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5201: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5202: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5203: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5204: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5205: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss
5206: ,PAA.ABS_INFORMATION9 --AS l_ptm_use_ss_daily_rate
5207: ,PAA.ABS_INFORMATION10 --AS l_ptm_reclaim_pay_max_6g

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

5200: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) --AS l_ptm_percentage
5201: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) --AS l_ptm_compensation_rate
5202: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION5) --AS l_ptm_paternity_days
5203: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION6) --AS l_ptm_pt_paternity_days
5204: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION7) --AS l_ptm_no_of_babies_born
5205: ,PAA.ABS_INFORMATION8 --AS l_ptm_reimburse_from_ss
5206: ,PAA.ABS_INFORMATION9 --AS l_ptm_use_ss_daily_rate
5207: ,PAA.ABS_INFORMATION10 --AS l_ptm_reclaim_pay_max_6g
5208: ,PAA.ABS_INFORMATION11 --AS l_ptm_hol_acc_ent

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

5704:
5705: -- rewriting cursor for changed segments
5706: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') AS Dateofadoption
5707: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Dateofbirth
5708: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS Comprate
5709: ,PAA.ABS_INFORMATION4 AS reimb_ss
5710: ,PAA.ABS_INFORMATION5 AS Use_ss_rate
5711: ,PAA.ABS_INFORMATION6 AS restrict_ss_sl
5712: ,PAA.ABS_INFORMATION7 AS dummy

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

5710: ,PAA.ABS_INFORMATION5 AS Use_ss_rate
5711: ,PAA.ABS_INFORMATION6 AS restrict_ss_sl
5712: ,PAA.ABS_INFORMATION7 AS dummy
5713: ,PAA.ABS_INFORMATION8 AS Daily_rate_option
5714: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION9) AS NumOfChildren
5715: ,PAA.ABS_INFORMATION15 AS intial_absence
5716: ,PAA.ABS_INFORMATION16 AS intial_abs_attend_id
5717: INTO l_adopt_doa
5718: ,l_adopt_dob

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

6216: */
6217:
6218: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') AS Dateofadoption
6219: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Dateofbirth
6220: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS PartTimePercent
6221: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS Comprate
6222: ,PAA.ABS_INFORMATION5 AS reimurse_ss--Use_ss_rate
6223: ,PAA.ABS_INFORMATION6 AS use_ss_rate
6224: ,PAA.ABS_INFORMATION7 AS reclaim_6g

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

6217:
6218: SELECT to_date(PAA.ABS_INFORMATION1,'yyyy/mm/dd hh24:mi:ss') AS Dateofadoption
6219: ,to_date(PAA.ABS_INFORMATION2,'yyyy/mm/dd hh24:mi:ss') AS Dateofbirth
6220: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) AS PartTimePercent
6221: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION4) AS Comprate
6222: ,PAA.ABS_INFORMATION5 AS reimurse_ss--Use_ss_rate
6223: ,PAA.ABS_INFORMATION6 AS use_ss_rate
6224: ,PAA.ABS_INFORMATION7 AS reclaim_6g
6225: ,PAA.ABS_INFORMATION9 AS dailtrate

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

6222: ,PAA.ABS_INFORMATION5 AS reimurse_ss--Use_ss_rate
6223: ,PAA.ABS_INFORMATION6 AS use_ss_rate
6224: ,PAA.ABS_INFORMATION7 AS reclaim_6g
6225: ,PAA.ABS_INFORMATION9 AS dailtrate
6226: ,fnd_number.canonical_to_number(PAA.ABS_INFORMATION10) AS NumOfChildren
6227: ,PAA.ABS_INFORMATION15 AS intial_absence
6228: ,PAA.ABS_INFORMATION16 AS intial_abs_attend_id
6229: INTO l_adopt_doa
6230: ,l_adopt_dob

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

6844: l_start_date := to_date(l_tab(l_cur).eevalue,'yyyy/mm/dd hh24:mi:ss') ;
6845: elsif l_tab(l_cur).eename = 'End Date' THEN
6846: l_end_date := to_date(l_tab(l_cur).eevalue,'yyyy/mm/dd hh24:mi:ss');
6847: elsif l_tab(l_cur).eename = 'Employer Period Daily Rate' THEN
6848: l_over_empr_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6849: elsif l_tab(l_cur).eename = 'Social Security Daily Rate' THEN
6850: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6851: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6852: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

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

6846: l_end_date := to_date(l_tab(l_cur).eevalue,'yyyy/mm/dd hh24:mi:ss');
6847: elsif l_tab(l_cur).eename = 'Employer Period Daily Rate' THEN
6848: l_over_empr_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6849: elsif l_tab(l_cur).eename = 'Social Security Daily Rate' THEN
6850: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6851: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6852: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6853: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6854: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

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

6848: l_over_empr_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6849: elsif l_tab(l_cur).eename = 'Social Security Daily Rate' THEN
6850: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6851: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6852: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6853: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6854: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6855: elsif l_tab(l_cur).eename = 'Social Security Period Days' THEN
6856: l_over_ss_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);

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

6850: l_over_ss_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6851: elsif l_tab(l_cur).eename = 'Reclaimable Daily Rate' THEN
6852: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6853: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6854: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6855: elsif l_tab(l_cur).eename = 'Social Security Period Days' THEN
6856: l_over_ss_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6857: elsif l_tab(l_cur).eename = 'Absence Category' THEN
6858: l_over_category := l_tab(l_cur).eevalue;

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

6852: l_over_reclaim_rate := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6853: elsif l_tab(l_cur).eename = 'Employer Period Days' THEN
6854: l_over_empr_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6855: elsif l_tab(l_cur).eename = 'Social Security Period Days' THEN
6856: l_over_ss_days := fnd_number.canonical_to_number(l_tab(l_cur).eevalue);
6857: elsif l_tab(l_cur).eename = 'Absence Category' THEN
6858: l_over_category := l_tab(l_cur).eevalue;
6859: end if;
6860: -- Check no. of input values of override element is 5

Line 7190: select fnd_number.canonical_to_number(GLOBAL_VALUE)

7186:
7187: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken
7188: -- from Global (NO_NATIONAL_INSURANCE_BASE_RATE) and not user table (NATIONAL_INSURANCE_BASE_RATE).
7189:
7190: select fnd_number.canonical_to_number(GLOBAL_VALUE)
7191: into l_g_rate
7192: from ff_globals_f
7193: where global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
7194: and LEGISLATION_CODE = 'NO'

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

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

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

7651: OPEN csr_get_screen_value(p_element_entry_id,l_ip_value_id);
7652: FETCH csr_get_screen_value INTO l_creator_id;
7653: CLOSE csr_get_screen_value;
7654:
7655: l_creator_id_num := fnd_number.canonical_to_number(l_creator_id);
7656:
7657: OPEN csr_get_baby_dob(l_creator_id_num);
7658: FETCH csr_get_baby_dob INTO l_dob;
7659: CLOSE csr_get_baby_dob;