APPS.GHR_SS_VIEWS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 294: p_assignment_id in pay_element_entries_f.assignment_id%type,

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

Line 309: pay_element_entries_f ele

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
313: and trunc(p_effective_date) between ele.effective_start_date

Line 426: FROM pay_element_entries_f eef,

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

Line 477: FROM pay_element_entries_f eef,

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

Line 833: p_assignment_id pay_element_entries_f.assignment_id%type;

829: l_proc varchar2(72);
830: l_new_element_name VARCHAR2(80);
831: l_input_curr_code varchar2(10);
832: p_effective_date date;
833: p_assignment_id pay_element_entries_f.assignment_id%type;
834:
835: CURSOR assignement_start_date(p_person_id NUMBER) IS
836: SELECT MIN(effective_start_date) effective_start_date,
837: MIN(assignment_id) assignment_id

Line 849: pay_element_entries_f ele

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
853: and trunc(p_effective_date) between ele.effective_start_date