APPS.GHR_SS_VIEWS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 269: p_assignment_id in pay_element_entries_f.assignment_id%type,

265: --
266: -- This function returns the currency code of an element on an effective date.
267:
268: Function retrieve_element_curr_code (p_element_name in pay_element_types_f.element_name%type,
269: p_assignment_id in pay_element_entries_f.assignment_id%type,
270: p_business_group_id in per_all_assignments_f.business_group_id%type,
271: p_effective_date in date ) return varchar2 is
272:
273: --

Line 284: pay_element_entries_f ele

280: Cursor c_ele_input_curr_code is
281:
282: select elt.input_currency_code input_curr_code
283: from pay_element_types_f elt,
284: pay_element_entries_f ele
285: where
286: trunc(p_effective_date) between elt.effective_start_date
287: and elt.effective_end_date
288: and trunc(p_effective_date) between ele.effective_start_date

Line 401: FROM pay_element_entries_f eef,

397:
398: CURSOR award_check (l_assignment_id NUMBER,
399: l_effective_date DATE ) IS
400: SELECT eef.element_entry_id
401: FROM pay_element_entries_f eef,
402: pay_element_types_f elt
403: WHERE eef.assignment_id = l_assignment_id
404: AND eef.effective_start_date <= l_effective_date
405: AND elt.element_type_id = eef.element_type_id

Line 452: FROM pay_element_entries_f eef,

448:
449: CURSOR bonus_check (l_assignment_id NUMBER,
450: l_effective_date DATE ) IS
451: SELECT eef.element_entry_id
452: FROM pay_element_entries_f eef,
453: pay_element_types_f elt
454: WHERE eef.assignment_id = l_assignment_id
455: AND eef.effective_start_date <= l_effective_date
456: AND elt.element_type_id = eef.element_type_id