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 2295: pay_element_types_f pet,

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

Line 2337: pay_element_types_f pet,

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

Line 2364: pay_element_types_f pet,

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