APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_ELEMENT_ENTRIES_V

Line 3402: FROM hr_h2pi_element_entries_v ele

3398:
3399: CURSOR csr_ed_element_entry (p_ele_id NUMBER,
3400: p_esd DATE) IS
3401: SELECT *
3402: FROM hr_h2pi_element_entries_v ele
3403: WHERE ele.element_entry_id = p_ele_id
3404: AND p_esd BETWEEN ele.effective_start_date
3405: AND ele.effective_end_date;
3406:

Line 3426: v_ed_ele hr_h2pi_element_entries_v%ROWTYPE;

3422:
3423: v_ud_ele hr_h2pi_element_entries%ROWTYPE;
3424: a_ud_sev eev_array := eev_array(NULL,NULL,NULL,NULL,NULL,NULL,NULL,
3425: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
3426: v_ed_ele hr_h2pi_element_entries_v%ROWTYPE;
3427:
3428: l_index NUMBER;
3429: a_input_value_id iv_array := iv_array(NULL,NULL,NULL,NULL,NULL,NULL,NULL,
3430: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

Line 4970: hr_h2pi_element_entries_v to_ele,

4966: SUM (fr_eev2.screen_entry_value) percentage,
4967: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
4968: FROM hr_h2pi_element_entry_values_v to_eev,
4969: hr_h2pi_element_entry_values_v to_eev2,
4970: hr_h2pi_element_entries_v to_ele,
4971: hr_h2pi_element_entry_values fr_eev,
4972: hr_h2pi_element_entry_values fr_eev2,
4973: hr_h2pi_element_entries fr_ele
4974: WHERE to_ele.element_entry_id = to_eev.element_entry_id

Line 4982: from hr_h2pi_element_entries_v to_ele_t

4978: AND fr_eev.client_id = p_from_client_id --
4979: AND fr_eev2.input_value_id = p_ud_iv_id2
4980: AND fr_eev2.client_id = p_from_client_id --
4981: AND to_ele.effective_start_date = (SELECT MAX(to_ele_t.effective_start_date)
4982: from hr_h2pi_element_entries_v to_ele_t
4983: WHERE to_ele_t.element_entry_id = to_ele.element_entry_id)
4984: AND to_eev.effective_start_date BETWEEN to_ele.effective_start_date
4985: AND to_ele.effective_end_date
4986: AND to_ele.element_entry_id = to_eev2.element_entry_id

Line 5025: hr_h2pi_element_entries_v to_ele,

5021: SUM (fr_eev2.screen_entry_value) percentage,
5022: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5023: FROM hr_h2pi_element_entry_values_v to_eev,
5024: hr_h2pi_element_entry_values_v to_eev2,
5025: hr_h2pi_element_entries_v to_ele,
5026: hr_h2pi_element_entry_values fr_eev,
5027: hr_h2pi_element_entry_values fr_eev2,
5028: hr_h2pi_element_entries fr_ele
5029: WHERE to_ele.element_entry_id = to_eev.element_entry_id

Line 5037: from hr_h2pi_element_entries_v to_ele_t

5033: AND fr_eev.client_id = p_from_client_id --
5034: AND fr_eev2.input_value_id = p_ud_iv_id2
5035: AND fr_eev2.client_id = p_from_client_id --
5036: AND to_ele.effective_start_date = (SELECT MAX(to_ele_t.effective_start_date)
5037: from hr_h2pi_element_entries_v to_ele_t
5038: WHERE to_ele_t.element_entry_id = to_ele.element_entry_id)
5039: AND to_eev.effective_start_date BETWEEN to_ele.effective_start_date
5040: AND to_ele.effective_end_date
5041: AND to_ele.element_entry_id = to_eev2.element_entry_id

Line 5078: hr_h2pi_element_entries_v to_ele,

5074: SUM (fr_eev2.screen_entry_value) percentage,
5075: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5076: FROM hr_h2pi_element_entry_values_v to_eev,
5077: hr_h2pi_element_entry_values_v to_eev2,
5078: hr_h2pi_element_entries_v to_ele,
5079: hr_h2pi_element_entry_values fr_eev,
5080: hr_h2pi_element_entry_values fr_eev2,
5081: hr_h2pi_element_entries fr_ele
5082: WHERE to_ele.element_entry_id = to_eev.element_entry_id

Line 5090: from hr_h2pi_element_entries_v to_ele_t

5086: AND fr_eev.client_id = p_from_client_id --
5087: AND fr_eev2.input_value_id = p_ud_iv_id2
5088: AND fr_eev2.client_id = p_from_client_id --
5089: AND to_ele.effective_start_date = (SELECT MAX(to_ele_t.effective_start_date)
5090: from hr_h2pi_element_entries_v to_ele_t
5091: WHERE to_ele_t.element_entry_id = to_ele.element_entry_id)
5092: AND to_eev.effective_start_date BETWEEN to_ele.effective_start_date
5093: AND to_ele.effective_end_date
5094: AND to_ele.element_entry_id = to_eev2.element_entry_id