APPS.BEN_ELEMENT_ENTRY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 153: from pay_assignment_actions d,

149: (c_assignment_id in number
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';

Line 178: from pay_assignment_actions d,

174: ,c_payroll_id in number
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

Line 295: pay_assignment_actions asgt_action,

291:
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'

Line 998: from pay_assignment_actions aa,

994: p_element_type_id number) is
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,