APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 295: FROM pay_element_entry_values_f

291: -- Cursor to fetch screen entry value
292: CURSOR csr_get_screen_ent_val
293: IS
294: SELECT screen_entry_value
295: FROM pay_element_entry_values_f
296: WHERE element_entry_id = p_element_entry_id
297: AND effective_start_date = p_effective_start_date
298: AND effective_end_date = p_effective_end_date
299: AND input_value_id = p_input_value_id;

Line 304: l_screen_ent_value pay_element_entry_values_f.screen_entry_value%TYPE;

300:
301: l_proc_name VARCHAR2(80)
302: := g_proc_name || 'get_screen_entry_value';
303: l_proc_step PLS_INTEGER;
304: l_screen_ent_value pay_element_entry_values_f.screen_entry_value%TYPE;
305: --
306: BEGIN
307: --
308: IF g_debug

Line 2127: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';

2123: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';
2124: i := i + 1;
2125: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2126: i := i + 1;
2127: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2128: i := i + 1;
2129: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2130: i := i + 1;
2131: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';

Line 3317: FROM pay_element_entry_values_f pev

3313: AND g_effective_date BETWEEN pel.effective_start_date
3314: AND pel.effective_end_date
3315: AND EXISTS(
3316: SELECT 1
3317: FROM pay_element_entry_values_f pev
3318: WHERE pev.element_entry_id = pee.element_entry_id
3319: AND pev.effective_start_date =
3320: pee.effective_start_date
3321: AND pev.effective_end_date = pee.effective_end_date

Line 5105: FROM pay_element_entry_values_f

5101: -- Cursor to fetch element entry value information
5102: CURSOR csr_get_ele_ent_val(c_element_entry_value_id NUMBER)
5103: IS
5104: SELECT input_value_id, screen_entry_value, element_entry_id
5105: FROM pay_element_entry_values_f
5106: WHERE element_entry_value_id = c_element_entry_value_id
5107: AND g_effective_date BETWEEN effective_start_date
5108: AND effective_end_date;
5109:

Line 5176: l_char pay_element_entry_values_f.screen_entry_value%TYPE;

5172: l_asg_start_date DATE;
5173: l_leaver_date DATE;
5174: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
5175: l_input_value_id NUMBER;
5176: l_char pay_element_entry_values_f.screen_entry_value%TYPE;
5177: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
5178: l_partnership_scheme VARCHAR2(30);
5179: i NUMBER;
5180: l_effective_end_date DATE;

Line 5620: ELSIF p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5616: END IF; -- End if of update_type check ...
5617: END IF; -- End if of row not found check ...
5618:
5619: CLOSE csr_get_ele_ent_info;
5620: ELSIF p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5621: THEN
5622: IF g_debug
5623: THEN
5624: l_proc_step := 100;