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 2145: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';

2141: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';
2142: i := i + 1;
2143: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2144: i := i + 1;
2145: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2146: i := i + 1;
2147: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2148: i := i + 1;
2149: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';

Line 3335: FROM pay_element_entry_values_f pev

3331: AND g_effective_date BETWEEN pel.effective_start_date
3332: AND pel.effective_end_date
3333: AND EXISTS(
3334: SELECT 1
3335: FROM pay_element_entry_values_f pev
3336: WHERE pev.element_entry_id = pee.element_entry_id
3337: AND pev.effective_start_date =
3338: pee.effective_start_date
3339: AND pev.effective_end_date = pee.effective_end_date

Line 5159: FROM pay_element_entry_values_f

5155: -- Cursor to fetch element entry value information
5156: CURSOR csr_get_ele_ent_val(c_element_entry_value_id NUMBER)
5157: IS
5158: SELECT input_value_id, screen_entry_value, element_entry_id
5159: FROM pay_element_entry_values_f
5160: WHERE element_entry_value_id = c_element_entry_value_id
5161: AND g_effective_date BETWEEN effective_start_date
5162: AND effective_end_date;
5163:

Line 5230: l_char pay_element_entry_values_f.screen_entry_value%TYPE;

5226: l_asg_start_date DATE;
5227: l_leaver_date DATE;
5228: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
5229: l_input_value_id NUMBER;
5230: l_char pay_element_entry_values_f.screen_entry_value%TYPE;
5231: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
5232: l_partnership_scheme VARCHAR2(30);
5233: i NUMBER;
5234: l_effective_end_date DATE;

Line 5682: ELSIF p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5678: END IF; -- End if of update_type check ...
5679: END IF; -- End if of row not found check ...
5680:
5681: CLOSE csr_get_ele_ent_info;
5682: ELSIF p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5683: THEN
5684: IF g_debug
5685: THEN
5686: l_proc_step := 100;