DBA Data[Home] [Help]

APPS.BEN_EXT_PAYROLL dependencies on PAY_ELEMENT_ENTRIES_F

Line 121: pay_element_entries_f ee,

117: ee.effective_end_date,
118: ee.element_entry_id
119: from
120: pay_element_entry_values_f eev,
121: pay_element_entries_f ee,
122: per_all_assignments_f asg,
123: pay_input_values_f iv
124: where
125: asg.person_id = p_person_id

Line 169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,

165: screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE,
166: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE,
167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE

Line 170: reason pay_element_entries_f.reason%TYPE,

166: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE,
167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );

Line 171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,

167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );
175:

Line 172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,

168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );
175:
176: pay get_csr_val;

Line 173: element_entry_id pay_element_entries_f.element_entry_id%TYPE

169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );
175:
176: pay get_csr_val;
177: --Changes for Penserver: Stop

Line 247: pay_element_entries_f ee,

243: ee.effective_end_date,
244: ee.element_entry_id
245: from
246: pay_element_entry_values_f eev,
247: pay_element_entries_f ee,
248: per_all_assignments_f asg,
249: per_all_people_f per,
250: pay_input_values_f iv,
251: pay_element_types_f et,

Line 323: pay_element_entries_f ee,

319: ee.effective_end_date,
320: ee.element_entry_id
321: from
322: pay_element_entry_values_f eev,
323: pay_element_entries_f ee,
324: per_all_assignments_f asg,
325: pay_input_values_f iv
326: where
327: asg.person_id = p_person_id

Line 366: pay_element_entries_f ee,

362: ee.effective_end_date,
363: ee.element_entry_id
364: from
365: pay_element_entry_values_f eev,
366: pay_element_entries_f ee,
367: per_all_assignments_f asg,
368: pay_input_values_f iv
369: where
370: asg.person_id = p_person_id