APPS.GHR_SS_VIEWS_PKG dependencies on PAY_ELEMENT_TYPES_F

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

289: End get_latest_perf_rating;
290: --
291: -- This function returns the currency code of an element on an effective date.
292:
293: Function retrieve_element_curr_code (p_element_name in pay_element_types_f.element_name%type,
294: p_assignment_id in pay_element_entries_f.assignment_id%type,
295: p_business_group_id in per_all_assignments_f.business_group_id%type,
296: p_effective_date in date ) return varchar2 is
297:

Line 308: from pay_element_types_f elt,

304:
305: Cursor c_ele_input_curr_code is
306:
307: select elt.input_currency_code input_curr_code
308: from pay_element_types_f elt,
309: pay_element_entries_f ele
310: where
311: trunc(p_effective_date) between elt.effective_start_date
312: and elt.effective_end_date

Line 427: pay_element_types_f elt

423: CURSOR award_check (l_assignment_id NUMBER,
424: l_effective_date DATE ) IS
425: SELECT eef.element_entry_id
426: FROM pay_element_entries_f eef,
427: pay_element_types_f elt
428: WHERE eef.assignment_id = l_assignment_id
429: AND eef.effective_start_date <= l_effective_date
430: AND elt.element_type_id = eef.element_type_id
431: AND eef.effective_start_date BETWEEN elt.effective_start_date

Line 478: pay_element_types_f elt

474: CURSOR bonus_check (l_assignment_id NUMBER,
475: l_effective_date DATE ) IS
476: SELECT eef.element_entry_id
477: FROM pay_element_entries_f eef,
478: pay_element_types_f elt
479: WHERE eef.assignment_id = l_assignment_id
480: AND eef.effective_start_date <= l_effective_date
481: AND elt.element_type_id = eef.element_type_id
482: AND eef.effective_start_date BETWEEN elt.effective_start_date

Line 824: p_element_name in pay_element_types_f.element_name%type,

820:
821: END get_per_ele_value_ason_date;
822:
823: Function get_elmt_curr_code_ason_dt (
824: p_element_name in pay_element_types_f.element_name%type,
825: p_person_id in number,
826: p_business_group_id in per_all_assignments_f.business_group_id%type)
827: return varchar2 is
828:

Line 848: from pay_element_types_f elt,

844: AND assignment_type in ('E','C');
845:
846: Cursor c_ele_input_curr_code is
847: select elt.input_currency_code input_curr_code
848: from pay_element_types_f elt,
849: pay_element_entries_f ele
850: where
851: trunc(p_effective_date) between elt.effective_start_date
852: and elt.effective_end_date