APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_RUN_RESULTS

Line 529: , pay_run_results RR

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
532: , pay_balance_types bal
533: --

Line 2103: ,pay_run_results prr

2099: -- AS 5/9/3 commented out some date and status criteria here as error was being raised incorrectly
2100: Select 'Y'
2101: from pay_payroll_actions ppa
2102: ,pay_assignment_actions paa
2103: ,pay_run_results prr
2104: where ppa.payroll_id + 0 = p_asg.payroll_id
2105: -- and ppa.date_earned < trunc(p_sickness_start_date,'MONTH')
2106: -- and to_char(ppa.date_earned,'MON-YYYY') = to_char(c_period,'MON-YYYY')
2107: and paa.assignment_id + 0 = c_assignment_id

Line 2127: pay_run_results prr_pst,

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,
2129: pay_element_types_f peltf,
2130: pay_assignment_actions pact,
2131: pay_payroll_actions ppac

Line 2128: pay_run_results prr_pet,

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,
2129: pay_element_types_f peltf,
2130: pay_assignment_actions pact,
2131: pay_payroll_actions ppac
2132: --

Line 2686: ,pay_run_results rr

2682: nvl(ee.creator_id,0) retro_asg_action,
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

Line 2852: pay_run_results rr,

2848: ,l_overlap_band3_days
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

Line 2994: ,pay_run_results rr

2990: g_gi_info_band4_iv_id,target.result_value,
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