[Home] [Help]
2116: ,ff_contexts ctx2
2117: ,pay_payroll_actions ppa
2118: ,pay_run_results rr
2119: ,pay_run_result_values rrv
2120: ,pay_input_values_f pivf
2121: ,pay_user_tables t
2122: ,pay_user_rows_f r
2123: ,pay_element_entries_f pee
2124: WHERE cde_dtl.action_context_type = 'PA'
2201: pay_run_result_values rrv,
2202: -- pay_action_information cde_dtl,
2203: pay_action_information cde_info_dtl
2204: ,pay_element_type_extra_info eei
2205: ,pay_input_values_f pivf
2206: where rr.run_result_id = p_run_result_id
2207: and rr.element_entry_id = pee.element_entry_id
2208: and pee.SOURCE_ASG_ACTION_ID is not null
2209: and pee.source_id = rr1.run_result_id
2292: ,ff_contexts ctx2
2293: ,pay_payroll_actions ppa
2294: ,pay_run_results rr
2295: ,pay_run_result_values rrv
2296: ,pay_input_values_f pivf
2297: ,pay_element_types_f petf
2298: ,pay_user_tables t
2299: ,pay_user_rows_f r
2300: WHERE ppa.business_group_id = p_business_group_id
2368: ,ff_contexts ctx2
2369: ,pay_payroll_actions ppa
2370: ,pay_run_results rr
2371: ,pay_run_result_values rrv
2372: ,pay_input_values_f pivf
2373: ,pay_element_types_f petf
2374: ,pay_user_tables t
2375: ,pay_user_rows_f r
2376: WHERE ppa.business_group_id = p_business_group_id
2419: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2420: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2421: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2422: FROM pay_run_result_values rrv
2423: ,pay_input_values_f piv
2424: WHERE rrv.run_result_id = l_rr_id
2425: AND piv.element_type_id = l_element_type_id
2426: AND piv.name IN ('Pay Value','Number of Days','Per Diem','Number of Days to be reported','Country')
2427: AND piv.input_value_id = rrv.input_value_id