APPS.GHR_GENERAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 157: p_element_entry_id in pay_element_entries_f.element_entry_id%type,

153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
156: p_option_code in ben_opt_f.short_code%type,
157: p_element_entry_id in pay_element_entries_f.element_entry_id%type,
158: p_object_version_number in pay_element_entries_f.object_version_number%type,
159: p_temps_cost in pay_element_entry_values_f.screen_entry_value%type) is
160:
161:

Line 158: p_object_version_number in pay_element_entries_f.object_version_number%type,

154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
156: p_option_code in ben_opt_f.short_code%type,
157: p_element_entry_id in pay_element_entries_f.element_entry_id%type,
158: p_object_version_number in pay_element_entries_f.object_version_number%type,
159: p_temps_cost in pay_element_entry_values_f.screen_entry_value%type) is
160:
161:
162: l_prog_count number;

Line 330: from pay_element_entries_f

326: and pgm_id = l_pgm_id;
327:
328: cursor c_get_ovn is
329: select object_version_number
330: from pay_element_entries_f
331: where element_entry_id = p_element_entry_id
332: and effective_start_date < p_effective_date
333: order by effective_start_date desc;
334:

Line 339: FROM pay_element_entries_f eef_new,

335: cursor c_get_new_element_details is
336: SELECT eef_new.element_entry_id,
337: eef_new.object_version_number,
338: eef_new.element_type_id
339: FROM pay_element_entries_f eef_new,
340: pay_element_types_f elt_new
341: WHERE eef_new.assignment_id = p_assignment_id
342: and elt_new.element_type_id = eef_new.element_type_id
343: AND eef_new.effective_start_date BETWEEN elt_new.effective_start_date AND elt_new.effective_end_date