DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on PAY_ELEMENT_TYPES_F

Line 54: pay_element_types_f pet2,

50: prr2.run_result_id,
51: paa.assignment_id
52: from pay_action_interlocks pai2,
53: pay_run_results prr2,
54: pay_element_types_f pet2,
55: pay_payroll_actions ppa,
56: pay_assignment_actions paa
57: where pai2.locking_action_id = p_assignment_action
58: and pai2.locked_action_id = prr2.assignment_action_id

Line 2300: pay_element_types_f pet,

2296: pay_act_id,
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,

Line 2346: pay_element_types_f pet,

2342: select fnd_number.canonical_to_number(rrv.result_value)
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

Line 2373: pay_element_types_f pet,

2369: into adj_value
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