APPS.BEN_ELEMENT_ENTRY dependencies on PAY_PAYROLL_ACTIONS

Line 154: pay_payroll_actions e

150: )
151: is
152: select 'Y'
153: from pay_assignment_actions d,
154: pay_payroll_actions e
155: where d.assignment_id = c_assignment_id
156: and d.payroll_action_id = e.payroll_action_id
157: and e.action_type <> 'X';
158: --

Line 179: pay_payroll_actions e,

175: ) is
176: select d.assignment_action_id,
177: g.end_date
178: from pay_assignment_actions d,
179: pay_payroll_actions e,
180: per_time_periods g
181: where d.assignment_id = c_assignment_id
182: and g.payroll_id = c_payroll_id
183: and g.payroll_id = e.payroll_id

Line 296: pay_payroll_actions pay_action,

292: cursor recurring_entries is
293: select 'Y'
294: from pay_run_results result,
295: pay_assignment_actions asgt_action,
296: pay_payroll_actions pay_action,
297: per_time_periods period
298: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)
299: and result.status <> 'U'
300: and result.source_type = 'E'

Line 999: pay_payroll_actions pa,

995: select qi.assignment_action_id,
996: qi.element_entry_id,
997: tp.end_date
998: from pay_assignment_actions aa,
999: pay_payroll_actions pa,
1000: pay_quickpay_inclusions qi,
1001: pay_element_links_f el,
1002: pay_element_entries_f ee,
1003: per_time_periods tp