APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_RUN_RESULT_VALUES

Line 527: from pay_run_result_values TARGET

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
531: , pay_payroll_actions PACT

Line 2123: From pay_run_result_values prrv_pst,

2119: max(fnd_date.canonical_to_date(prrv_pet.result_value)) Pmt_end_dt,
2120: piv_pst.input_value_id pmt_start_input_id,
2121: piv_pet.input_value_id pmt_end_input_id
2122: --
2123: From pay_run_result_values prrv_pst,
2124: pay_run_result_values prrv_pet,
2125: pay_input_values_f piv_pst,
2126: pay_input_values_f piv_pet,
2127: pay_run_results prr_pst,

Line 2124: pay_run_result_values prrv_pet,

2120: piv_pst.input_value_id pmt_start_input_id,
2121: piv_pet.input_value_id pmt_end_input_id
2122: --
2123: From pay_run_result_values prrv_pst,
2124: pay_run_result_values prrv_pet,
2125: pay_input_values_f piv_pst,
2126: pay_input_values_f piv_pet,
2127: pay_run_results prr_pst,
2128: pay_run_results prr_pet,

Line 2687: ,pay_run_result_values guarantee_id

2683: epd.adjustment_type retro_adj_type
2684: from pay_assignment_actions assact
2685: ,pay_payroll_actions pact
2686: ,pay_run_results rr
2687: ,pay_run_result_values guarantee_id
2688: ,pay_run_result_values parent_absence_id
2689: ,pay_run_result_values target
2690: ,pay_entry_process_details epd
2691: ,pay_element_entries_f ee

Line 2688: ,pay_run_result_values parent_absence_id

2684: from pay_assignment_actions assact
2685: ,pay_payroll_actions pact
2686: ,pay_run_results rr
2687: ,pay_run_result_values guarantee_id
2688: ,pay_run_result_values parent_absence_id
2689: ,pay_run_result_values target
2690: ,pay_entry_process_details epd
2691: ,pay_element_entries_f ee
2692: where assact.assignment_id = p_assignment_id

Line 2689: ,pay_run_result_values target

2685: ,pay_payroll_actions pact
2686: ,pay_run_results rr
2687: ,pay_run_result_values guarantee_id
2688: ,pay_run_result_values parent_absence_id
2689: ,pay_run_result_values target
2690: ,pay_entry_process_details epd
2691: ,pay_element_entries_f ee
2692: where assact.assignment_id = p_assignment_id
2693: and assact.payroll_action_id = pact.payroll_action_id

Line 2853: pay_run_result_values rrv_end,

2849: ,l_overlap_band4_days
2850: from pay_assignment_actions assact,
2851: pay_payroll_actions pact,
2852: pay_run_results rr,
2853: pay_run_result_values rrv_end,
2854: pay_run_result_values rrv_start,
2855: pay_run_result_values rrv_guarantee,
2856: pay_run_result_values target
2857: where assact.assignment_id = P_asg.assignment_id

Line 2854: pay_run_result_values rrv_start,

2850: from pay_assignment_actions assact,
2851: pay_payroll_actions pact,
2852: pay_run_results rr,
2853: pay_run_result_values rrv_end,
2854: pay_run_result_values rrv_start,
2855: pay_run_result_values rrv_guarantee,
2856: pay_run_result_values target
2857: where assact.assignment_id = P_asg.assignment_id
2858: and assact.action_status = 'C'

Line 2855: pay_run_result_values rrv_guarantee,

2851: pay_payroll_actions pact,
2852: pay_run_results rr,
2853: pay_run_result_values rrv_end,
2854: pay_run_result_values rrv_start,
2855: pay_run_result_values rrv_guarantee,
2856: pay_run_result_values target
2857: where assact.assignment_id = P_asg.assignment_id
2858: and assact.action_status = 'C'
2859: and assact.payroll_action_id = pact.payroll_action_id

Line 2856: pay_run_result_values target

2852: pay_run_results rr,
2853: pay_run_result_values rrv_end,
2854: pay_run_result_values rrv_start,
2855: pay_run_result_values rrv_guarantee,
2856: pay_run_result_values target
2857: where assact.assignment_id = P_asg.assignment_id
2858: and assact.action_status = 'C'
2859: and assact.payroll_action_id = pact.payroll_action_id
2860: and pact.action_type in ('R','Q','B','V')

Line 2995: ,pay_run_result_values guarantee_id

2991: g_gi_i_r_band4_iv_id, target.result_value,0)),0)
2992: from pay_assignment_actions assact
2993: ,pay_payroll_actions pact
2994: ,pay_run_results rr
2995: ,pay_run_result_values guarantee_id
2996: ,pay_run_result_values payment_date
2997: ,pay_run_result_values target
2998: where assact.assignment_id = p_asg.assignment_id
2999: and assact.payroll_action_id = pact.payroll_action_id

Line 2996: ,pay_run_result_values payment_date

2992: from pay_assignment_actions assact
2993: ,pay_payroll_actions pact
2994: ,pay_run_results rr
2995: ,pay_run_result_values guarantee_id
2996: ,pay_run_result_values payment_date
2997: ,pay_run_result_values target
2998: where assact.assignment_id = p_asg.assignment_id
2999: and assact.payroll_action_id = pact.payroll_action_id
3000: and pact.action_type in ('R', 'Q', 'V', 'B')

Line 2997: ,pay_run_result_values target

2993: ,pay_payroll_actions pact
2994: ,pay_run_results rr
2995: ,pay_run_result_values guarantee_id
2996: ,pay_run_result_values payment_date
2997: ,pay_run_result_values target
2998: where assact.assignment_id = p_asg.assignment_id
2999: and assact.payroll_action_id = pact.payroll_action_id
3000: and pact.action_type in ('R', 'Q', 'V', 'B')
3001: and assact.assignment_action_id = rr.assignment_action_id

Line 4401: from pay_run_result_values rv,

4397: CURSOR ele_input_res(p_run_result_id in NUMBER) is
4398: select name,
4399: uom,
4400: substr(result_value,1,10) result_value
4401: from pay_run_result_values rv,
4402: pay_input_values_f i
4403: where rv.run_result_id = p_run_result_id
4404: and rv.input_value_id + 0 = i.input_value_id
4405: order by display_sequence;