DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on PAY_RUN_RESULT_VALUES

Line 2301: pay_run_result_values rrv,

2297: run_date_earned
2298: from
2299: pay_input_values_f piv,
2300: pay_element_types_f pet,
2301: pay_run_result_values rrv,
2302: pay_run_results prr2,
2303: pay_run_results prr,
2304: pay_assignment_actions paa,
2305: pay_payroll_actions ppa

Line 2347: pay_run_result_values rrv,

2343: into adj_value
2344: from
2345: pay_input_values_f piv,
2346: pay_element_types_f pet,
2347: pay_run_result_values rrv,
2348: pay_run_results prr2,
2349: pay_run_results prr
2350: where prr.run_result_id = p_run_result
2351: and prr.assignment_action_id = assign_action_id

Line 2374: pay_run_result_values rrv,

2370: from
2371: pay_element_entries_f pee,
2372: pay_input_values_f piv,
2373: pay_element_types_f pet,
2374: pay_run_result_values rrv,
2375: pay_run_results prr2,
2376: pay_run_results prr
2377: where pee.target_entry_id=entry
2378: and pee.assignment_id = assign_id

Line 2763: from pay_run_result_values prrv,

2759: cursor get_orgs (p_asg_action in number,
2760: p_org_context_name in varchar2)
2761: is
2762: select distinct (prrv.result_value) organization_id
2763: from pay_run_result_values prrv,
2764: pay_input_values_f piv,
2765: pay_run_results prr,
2766: pay_assignment_actions paa,
2767: pay_payroll_actions ppa,