APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1193: FROM pay_element_entry_values_f

1189: -- Cursor to fetch screen entry value
1190: CURSOR csr_get_screen_ent_val
1191: IS
1192: SELECT screen_entry_value
1193: FROM pay_element_entry_values_f
1194: WHERE element_entry_id = p_element_entry_id
1195: AND effective_start_date = p_effective_start_date
1196: AND effective_end_date = p_effective_end_date
1197: AND input_value_id = p_input_value_id;

Line 1202: l_screen_ent_value pay_element_entry_values_f.screen_entry_value%TYPE;

1198:
1199: l_proc_name VARCHAR2(80)
1200: := g_proc_name || 'get_screen_entry_value';
1201: l_proc_step PLS_INTEGER;
1202: l_screen_ent_value pay_element_entry_values_f.screen_entry_value%TYPE;
1203: --
1204: BEGIN
1205: --
1206: IF g_debug

Line 3494: FROM pay_element_entry_values_f

3490: ,c_effective_end_date DATE
3491: )
3492: IS
3493: SELECT screen_entry_value, effective_start_date, effective_end_date
3494: FROM pay_element_entry_values_f
3495: WHERE element_entry_id = c_element_entry_id
3496: AND (
3497: effective_start_date BETWEEN c_effective_start_date
3498: AND c_effective_end_date

Line 3514: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;

3510: l_proc_step PLS_INTEGER;
3511: l_rec_screen_ent_val csr_get_screen_ent_val%ROWTYPE;
3512: l_tab_ni_cont_out_bals t_varchar2;
3513: l_effective_end_date DATE;
3514: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;
3515: l_ni_pension pay_element_entry_values_f.screen_entry_value%TYPE;
3516: i NUMBER;
3517: l_ni_bal_name t_varchar2;
3518: l_return VARCHAR2(10);

Line 3515: l_ni_pension pay_element_entry_values_f.screen_entry_value%TYPE;

3511: l_rec_screen_ent_val csr_get_screen_ent_val%ROWTYPE;
3512: l_tab_ni_cont_out_bals t_varchar2;
3513: l_effective_end_date DATE;
3514: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;
3515: l_ni_pension pay_element_entry_values_f.screen_entry_value%TYPE;
3516: i NUMBER;
3517: l_ni_bal_name t_varchar2;
3518: l_return VARCHAR2(10);
3519: l_index NUMBER;