APPS.GHR_SS_VIEWS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 268: Function retrieve_element_curr_code (p_element_name in pay_element_types_f.element_name%type,

264: End get_latest_perf_rating;
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:

Line 283: from pay_element_types_f elt,

279:
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

Line 402: pay_element_types_f elt

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
406: AND eef.effective_start_date BETWEEN elt.effective_start_date

Line 453: pay_element_types_f elt

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
457: AND eef.effective_start_date BETWEEN elt.effective_start_date