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

Line 525: select sum(decode(trunc(spact.effective_date,'YYYY'),c_start_yr1,fnd_number.canonical_to_number(TARGET.result_value))) pymt_yr1,

521: cursor c_get_payment(c_balance_name varchar2,
522: c_start_yr1 date,
523: c_start_yr2 date,
524: c_end_yrs date) is
525: select sum(decode(trunc(spact.effective_date,'YYYY'),c_start_yr1,fnd_number.canonical_to_number(TARGET.result_value))) pymt_yr1,
526: sum(decode(trunc(spact.effective_date,'YYYY'),c_start_yr2,fnd_number.canonical_to_number(TARGET.result_value))) pymt_yr2
527: from pay_run_result_values TARGET
528: , pay_balance_feeds_f FEED
529: , pay_run_results RR

Line 526: sum(decode(trunc(spact.effective_date,'YYYY'),c_start_yr2,fnd_number.canonical_to_number(TARGET.result_value))) pymt_yr2

522: c_start_yr1 date,
523: c_start_yr2 date,
524: c_end_yrs date) is
525: select sum(decode(trunc(spact.effective_date,'YYYY'),c_start_yr1,fnd_number.canonical_to_number(TARGET.result_value))) pymt_yr1,
526: sum(decode(trunc(spact.effective_date,'YYYY'),c_start_yr2,fnd_number.canonical_to_number(TARGET.result_value))) pymt_yr2
527: from pay_run_result_values TARGET
528: , pay_balance_feeds_f FEED
529: , pay_run_results RR
530: , pay_assignment_actions ASSACT

Line 2652: g_gi_info_net_iv_id,fnd_number.canonical_to_number(target.result_value),

2648: -- Net Payment Adjustment IJSS Gross Best Method for each Guarantee ID
2649: select /*+ORDERED */
2650: assact.action_sequence action_sequence,
2651: nvl(sum(decode(target.input_value_id,
2652: g_gi_info_net_iv_id,fnd_number.canonical_to_number(target.result_value),
2653: g_gi_i_r_net_iv_id, fnd_number.canonical_to_number(target.result_value),
2654: 0)),0) previous_net,
2655: nvl(sum(decode(target.input_value_id,
2656: g_gi_info_gi_payment_iv_id,

Line 2653: g_gi_i_r_net_iv_id, fnd_number.canonical_to_number(target.result_value),

2649: select /*+ORDERED */
2650: assact.action_sequence action_sequence,
2651: nvl(sum(decode(target.input_value_id,
2652: g_gi_info_net_iv_id,fnd_number.canonical_to_number(target.result_value),
2653: g_gi_i_r_net_iv_id, fnd_number.canonical_to_number(target.result_value),
2654: 0)),0) previous_net,
2655: nvl(sum(decode(target.input_value_id,
2656: g_gi_info_gi_payment_iv_id,
2657: fnd_number.canonical_to_number(target.result_value),

Line 2657: fnd_number.canonical_to_number(target.result_value),

2653: g_gi_i_r_net_iv_id, fnd_number.canonical_to_number(target.result_value),
2654: 0)),0) previous_net,
2655: nvl(sum(decode(target.input_value_id,
2656: g_gi_info_gi_payment_iv_id,
2657: fnd_number.canonical_to_number(target.result_value),
2658: g_gi_i_r_gi_payment_iv_id,
2659: fnd_number.canonical_to_number(target.result_value),
2660: 0)),0) previous_payment,
2661: nvl(sum(decode(target.input_value_id,

Line 2659: fnd_number.canonical_to_number(target.result_value),

2655: nvl(sum(decode(target.input_value_id,
2656: g_gi_info_gi_payment_iv_id,
2657: fnd_number.canonical_to_number(target.result_value),
2658: g_gi_i_r_gi_payment_iv_id,
2659: fnd_number.canonical_to_number(target.result_value),
2660: 0)),0) previous_payment,
2661: nvl(sum(decode(target.input_value_id,
2662: g_gi_info_adjustment_iv_id,
2663: fnd_number.canonical_to_number(target.result_value),

Line 2663: fnd_number.canonical_to_number(target.result_value),

2659: fnd_number.canonical_to_number(target.result_value),
2660: 0)),0) previous_payment,
2661: nvl(sum(decode(target.input_value_id,
2662: g_gi_info_adjustment_iv_id,
2663: fnd_number.canonical_to_number(target.result_value),
2664: g_gi_i_r_adjustment_iv_id,
2665: fnd_number.canonical_to_number(target.result_value),
2666: 0)),0) previous_adjustment,
2667: nvl(sum(decode(target.input_value_id,

Line 2665: fnd_number.canonical_to_number(target.result_value),

2661: nvl(sum(decode(target.input_value_id,
2662: g_gi_info_adjustment_iv_id,
2663: fnd_number.canonical_to_number(target.result_value),
2664: g_gi_i_r_adjustment_iv_id,
2665: fnd_number.canonical_to_number(target.result_value),
2666: 0)),0) previous_adjustment,
2667: nvl(sum(decode(target.input_value_id,
2668: g_gi_info_ijss_gross_iv_id,
2669: fnd_number.canonical_to_number(target.result_value),

Line 2669: fnd_number.canonical_to_number(target.result_value),

2665: fnd_number.canonical_to_number(target.result_value),
2666: 0)),0) previous_adjustment,
2667: nvl(sum(decode(target.input_value_id,
2668: g_gi_info_ijss_gross_iv_id,
2669: fnd_number.canonical_to_number(target.result_value),
2670: g_gi_i_r_ijss_gross_iv_id,
2671: fnd_number.canonical_to_number(target.result_value),
2672: 0)),0) previous_IJSS_gross,
2673: max(decode(target.input_value_id,

Line 2671: fnd_number.canonical_to_number(target.result_value),

2667: nvl(sum(decode(target.input_value_id,
2668: g_gi_info_ijss_gross_iv_id,
2669: fnd_number.canonical_to_number(target.result_value),
2670: g_gi_i_r_ijss_gross_iv_id,
2671: fnd_number.canonical_to_number(target.result_value),
2672: 0)),0) previous_IJSS_gross,
2673: max(decode(target.input_value_id,
2674: g_gi_info_end_date_iv_id,
2675: fnd_date.canonical_to_date(target.result_value),

Line 2764: for a in get_audit(fnd_number.number_to_canonical( p_parent_absence_id),

2760: begin
2761: -- fetch the audit payments for this absence and guarantee
2762: -- previous_net, previous_payment, previous_adjustment, previous_IJSS_gross, best_method
2763:
2764: for a in get_audit(fnd_number.number_to_canonical( p_parent_absence_id),
2765: fnd_number.number_to_canonical(p_gi_id),
2766: p_asg.assignment_id,
2767: nvl(g_absence_calc.parent_absence_start_date,
2768: to_date('01/01/0001','dd/mm/yyyy'))) loop

Line 2765: fnd_number.number_to_canonical(p_gi_id),

2761: -- fetch the audit payments for this absence and guarantee
2762: -- previous_net, previous_payment, previous_adjustment, previous_IJSS_gross, best_method
2763:
2764: for a in get_audit(fnd_number.number_to_canonical( p_parent_absence_id),
2765: fnd_number.number_to_canonical(p_gi_id),
2766: p_asg.assignment_id,
2767: nvl(g_absence_calc.parent_absence_start_date,
2768: to_date('01/01/0001','dd/mm/yyyy'))) loop
2769:

Line 3061: open csr_get_band_usage(fnd_number.number_to_canonical(p_gi_id),

3057: if g_gi_info_element_type_id is null then
3058: set_global_ids(p_effective_date => l_date_to);
3059: end if;
3060: -- Now get the Band usage over the period
3061: open csr_get_band_usage(fnd_number.number_to_canonical(p_gi_id),
3062: fnd_date.date_to_canonical(l_date_from),
3063: fnd_date.date_to_canonical(l_date_to));
3064: fetch csr_get_band_usage into
3065: l_total_band1_days

Line 3647: ,fnd_number.canonical_to_number(G.screen_entry_value) guarantee_id

3643: p_effective_date date ) IS
3644: -- fetch FR_SICK_BENEFIT element entries that are relate to this absence as of the end
3645: -- date of the absence
3646: select ENT.element_entry_id
3647: ,fnd_number.canonical_to_number(G.screen_entry_value) guarantee_id
3648: ,max(decode(ENT_PT.input_value_id,g_ben_guarantee_type_iv_id,ENT_PT.screen_entry_value,null)) guarantee_type
3649: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_waiting_days_iv_id,ENT_PT.screen_entry_value,null))) waiting_days
3650: ,max(decode(ENT_PT.input_value_id,g_ben_duration_iv_id,ENT_PT.screen_entry_value,null)) duration
3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1

Line 3649: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_waiting_days_iv_id,ENT_PT.screen_entry_value,null))) waiting_days

3645: -- date of the absence
3646: select ENT.element_entry_id
3647: ,fnd_number.canonical_to_number(G.screen_entry_value) guarantee_id
3648: ,max(decode(ENT_PT.input_value_id,g_ben_guarantee_type_iv_id,ENT_PT.screen_entry_value,null)) guarantee_type
3649: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_waiting_days_iv_id,ENT_PT.screen_entry_value,null))) waiting_days
3650: ,max(decode(ENT_PT.input_value_id,g_ben_duration_iv_id,ENT_PT.screen_entry_value,null)) duration
3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1
3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate
3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2

Line 3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1

3647: ,fnd_number.canonical_to_number(G.screen_entry_value) guarantee_id
3648: ,max(decode(ENT_PT.input_value_id,g_ben_guarantee_type_iv_id,ENT_PT.screen_entry_value,null)) guarantee_type
3649: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_waiting_days_iv_id,ENT_PT.screen_entry_value,null))) waiting_days
3650: ,max(decode(ENT_PT.input_value_id,g_ben_duration_iv_id,ENT_PT.screen_entry_value,null)) duration
3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1
3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate
3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2
3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3

Line 3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate

3648: ,max(decode(ENT_PT.input_value_id,g_ben_guarantee_type_iv_id,ENT_PT.screen_entry_value,null)) guarantee_type
3649: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_waiting_days_iv_id,ENT_PT.screen_entry_value,null))) waiting_days
3650: ,max(decode(ENT_PT.input_value_id,g_ben_duration_iv_id,ENT_PT.screen_entry_value,null)) duration
3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1
3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate
3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2
3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3
3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate

Line 3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2

3649: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_waiting_days_iv_id,ENT_PT.screen_entry_value,null))) waiting_days
3650: ,max(decode(ENT_PT.input_value_id,g_ben_duration_iv_id,ENT_PT.screen_entry_value,null)) duration
3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1
3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate
3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2
3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3
3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate
3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4

Line 3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate

3650: ,max(decode(ENT_PT.input_value_id,g_ben_duration_iv_id,ENT_PT.screen_entry_value,null)) duration
3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1
3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate
3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2
3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3
3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate
3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4
3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate

Line 3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3

3651: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_iv_id,ENT_PT.screen_entry_value,null))) band1
3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate
3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2
3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3
3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate
3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4
3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate
3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance

Line 3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate

3652: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band1_rate_iv_id,ENT_PT.screen_entry_value,null))) b1_rate
3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2
3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3
3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate
3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4
3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate
3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance
3660: from pay_element_entry_values_f ENT_PT

Line 3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4

3653: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_iv_id,ENT_PT.screen_entry_value,null))) band2
3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3
3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate
3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4
3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate
3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance
3660: from pay_element_entry_values_f ENT_PT
3661: ,pay_element_entry_values_f G

Line 3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate

3654: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band2_rate_iv_id,ENT_PT.screen_entry_value,null))) b2_rate
3655: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_iv_id,ENT_PT.screen_entry_value,null))) band3
3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate
3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4
3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate
3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance
3660: from pay_element_entry_values_f ENT_PT
3661: ,pay_element_entry_values_f G
3662: ,pay_element_entries_f ENT

Line 3678: group by fnd_number.canonical_to_number(G.screen_entry_value), ENT.element_entry_id

3674: and ENT.effective_start_date = ENT_PT.effective_start_date
3675: and ENT.effective_end_date = ENT_PT.effective_end_date
3676: and ENT.effective_start_date = G.effective_start_date
3677: and ENT.effective_end_date = G.effective_end_date
3678: group by fnd_number.canonical_to_number(G.screen_entry_value), ENT.element_entry_id
3679: order by 2,1;
3680:
3681: l_guarantee_id number;
3682: l_effective_end_date date;