APPS.GHR_HISTORY_FETCH dependencies on PAY_ELEMENT_TYPES_F

Line 1791: (p_element_name in pay_element_types_f.element_name%type,

1787: raise;
1788: End fetch_element_entry_value;
1789:
1790: Procedure fetch_element_entry_value
1791: (p_element_name in pay_element_types_f.element_name%type,
1792: p_input_value_name in pay_input_values_f.name%type,
1793: p_assignment_id in per_assignments_f.assignment_id%type,
1794: p_date_effective in date,
1795: p_screen_entry_value out nocopy pay_element_entry_values_f.screen_entry_value%type

Line 1808: l_element_type_id pay_element_types_f.element_type_id%type;

1804: l_input_value_id pay_element_entry_values_f.input_value_id%type;
1805: l_element_link_id pay_element_entries_f.element_link_id%type;
1806: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1807: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
1808: l_element_type_id pay_element_types_f.element_type_id%type;
1809: l_processing_type pay_element_types.processing_type%type;
1810:
1811: Cursor fetch_element_entry_value_id(p_element_name IN VARCHAR2
1812: ,p_bg_id IN NUMBER)

Line 1815: from pay_element_types_f elt,

1811: Cursor fetch_element_entry_value_id(p_element_name IN VARCHAR2
1812: ,p_bg_id IN NUMBER)
1813: is
1814: select eev.element_entry_value_id
1815: from pay_element_types_f elt,
1816: pay_input_values_f ipv,
1817: pay_element_entries_f ele,
1818: pay_element_entry_values_f eev
1819: where trunc(p_date_effective) between elt.effective_start_date

Line 1945: p_element_name in pay_element_types_f.element_name%type

1941: End if;
1942: End fetch_element_entry_value;
1943:
1944: Procedure fetch_element_info_cor (
1945: p_element_name in pay_element_types_f.element_name%type
1946: ,p_input_value_name in pay_input_values_f.name%type
1947: ,p_assignment_id in pay_element_entries_f.assignment_id%type
1948: ,p_effective_date in date
1949: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type

Line 1962: l_processing_type pay_element_types_f.processing_type%type;

1958: l_session ghr_history_api.g_session_var_type;
1959: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1960: l_input_value_id pay_input_values_f.input_value_id%type;
1961: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1962: l_processing_type pay_element_types_f.processing_type%type;
1963: l_element_type_id pay_element_types_f.element_type_id%type;
1964: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
1965: l_element_entry_data pay_element_entry_values_f%rowtype;
1966: l_result varchar2(30);

Line 1963: l_element_type_id pay_element_types_f.element_type_id%type;

1959: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1960: l_input_value_id pay_input_values_f.input_value_id%type;
1961: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1962: l_processing_type pay_element_types_f.processing_type%type;
1963: l_element_type_id pay_element_types_f.element_type_id%type;
1964: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
1965: l_element_entry_data pay_element_entry_values_f%rowtype;
1966: l_result varchar2(30);
1967:

Line 1973: from pay_element_types_f elt

1969: --
1970: Cursor c_ele_type(p_element_name VARCHAR2,p_bg_id NUMBER) is
1971: select elt.element_type_id,
1972: elt.processing_type
1973: from pay_element_types_f elt
1974: where upper(elt.element_name) = upper(p_element_name)
1975: and p_effective_date
1976: between elt.effective_start_date and elt.effective_end_date
1977: and (elt.business_group_id is null or elt.business_group_id=p_bg_id);