DBA Data[Home] [Help]

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_RUN_RESULTS

Line 2107: from pay_run_results runs

2103: /*Bug 3654766 - Changed the cursor to improve performance and also
2104: to consider the assignment action id into account.*/
2105: cursor csr_get_rate is
2106: select to_number(result.result_value)
2107: from pay_run_results runs
2108: , pay_input_values_f input
2109: , pay_run_result_values result
2110: , pay_assignment_actions paa
2111: , pay_assignment_actions cur_paa

Line 2287: ,pay_run_results prr

2283: IS
2284: --
2285: SELECT to_number(nvl(prrv.result_value,0))
2286: FROM pay_run_result_values prrv
2287: ,pay_run_results prr
2288: ,pay_element_types_f alp_pet
2289: ,pay_input_values_f alp_piv
2290: ,pay_element_entries_f pee
2291: ,pay_element_links_f pel