DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on PAY_RUN_RESULT_VALUES

Line 2296: pay_run_result_values rrv,

2292: run_date_earned
2293: from
2294: pay_input_values_f piv,
2295: pay_element_types_f pet,
2296: pay_run_result_values rrv,
2297: pay_run_results prr2,
2298: pay_run_results prr,
2299: pay_assignment_actions paa,
2300: pay_payroll_actions ppa

Line 2338: pay_run_result_values rrv,

2334: into adj_value
2335: from
2336: pay_input_values_f piv,
2337: pay_element_types_f pet,
2338: pay_run_result_values rrv,
2339: pay_run_results prr2,
2340: pay_run_results prr
2341: where prr.run_result_id = p_run_result
2342: and prr.assignment_action_id = assign_action_id

Line 2365: pay_run_result_values rrv,

2361: from
2362: pay_element_entries_f pee,
2363: pay_input_values_f piv,
2364: pay_element_types_f pet,
2365: pay_run_result_values rrv,
2366: pay_run_results prr2,
2367: pay_run_results prr
2368: where pee.target_entry_id=entry
2369: and pee.assignment_id = assign_id

Line 2725: from pay_run_result_values prrv,

2721: is
2722: select /*+ use_nl(prrv piv)
2723: index(piv pay_input_values_f_pk) */
2724: distinct (prrv.result_value) organization_id
2725: from pay_run_result_values prrv,
2726: pay_input_values_f piv,
2727: pay_run_results prr,
2728: pay_assignment_actions paa,
2729: pay_payroll_actions ppa,