APPS.GHR_HISTORY_FETCH dependencies on PAY_ELEMENT_TYPES_F

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

1887: raise;
1888: End fetch_element_entry_value;
1889:
1890: Procedure fetch_element_entry_value
1891: (p_element_name in pay_element_types_f.element_name%type,
1892: p_input_value_name in pay_input_values_f.name%type,
1893: p_assignment_id in per_assignments_f.assignment_id%type,
1894: p_date_effective in date,
1895: p_screen_entry_value out nocopy pay_element_entry_values_f.screen_entry_value%type

Line 1908: l_element_type_id pay_element_types_f.element_type_id%type;

1904: l_input_value_id pay_element_entry_values_f.input_value_id%type;
1905: l_element_link_id pay_element_entries_f.element_link_id%type;
1906: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1907: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
1908: l_element_type_id pay_element_types_f.element_type_id%type;
1909: l_processing_type pay_element_types.processing_type%type;
1910:
1911: Cursor fetch_element_entry_value_id(p_element_name IN VARCHAR2
1912: ,p_bg_id IN NUMBER)

Line 1915: from pay_element_types_f elt,

1911: Cursor fetch_element_entry_value_id(p_element_name IN VARCHAR2
1912: ,p_bg_id IN NUMBER)
1913: is
1914: select eev.element_entry_value_id
1915: from pay_element_types_f elt,
1916: pay_input_values_f ipv,
1917: pay_element_entries_f ele,
1918: pay_element_entry_values_f eev
1919: where trunc(p_date_effective) between elt.effective_start_date

Line 2045: p_element_name in pay_element_types_f.element_name%type

2041: End if;
2042: End fetch_element_entry_value;
2043:
2044: Procedure fetch_element_info_cor (
2045: p_element_name in pay_element_types_f.element_name%type
2046: ,p_input_value_name in pay_input_values_f.name%type
2047: ,p_assignment_id in pay_element_entries_f.assignment_id%type
2048: ,p_effective_date in date
2049: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type

Line 2062: l_processing_type pay_element_types_f.processing_type%type;

2058: l_session ghr_history_api.g_session_var_type;
2059: l_element_entry_id pay_element_entries_f.element_entry_id%type;
2060: l_input_value_id pay_input_values_f.input_value_id%type;
2061: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2062: l_processing_type pay_element_types_f.processing_type%type;
2063: l_element_type_id pay_element_types_f.element_type_id%type;
2064: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
2065: l_element_entry_data pay_element_entry_values_f%rowtype;
2066: l_result varchar2(30);

Line 2063: l_element_type_id pay_element_types_f.element_type_id%type;

2059: l_element_entry_id pay_element_entries_f.element_entry_id%type;
2060: l_input_value_id pay_input_values_f.input_value_id%type;
2061: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2062: l_processing_type pay_element_types_f.processing_type%type;
2063: l_element_type_id pay_element_types_f.element_type_id%type;
2064: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
2065: l_element_entry_data pay_element_entry_values_f%rowtype;
2066: l_result varchar2(30);
2067:

Line 2073: from pay_element_types_f elt

2069: --
2070: Cursor c_ele_type(p_element_name VARCHAR2,p_bg_id NUMBER) is
2071: select elt.element_type_id,
2072: elt.processing_type
2073: from pay_element_types_f elt
2074: where upper(elt.element_name) = upper(p_element_name)
2075: and p_effective_date
2076: between elt.effective_start_date and elt.effective_end_date
2077: and (elt.business_group_id is null or elt.business_group_id=p_bg_id);