APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1263: FROM pay_element_entry_values_f val

1259: IS
1260: CURSOR c_entry_value
1261: IS
1262: SELECT val.screen_entry_value
1263: FROM pay_element_entry_values_f val
1264: ,pay_input_values_f inputs
1265: WHERE val.input_value_id = inputs.input_value_id
1266: AND val.element_entry_id = p_element_entry_id
1267: AND inputs.name = p_input_name

Line 1272: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;

1268: AND inputs.legislation_code = 'IN'
1269: AND p_effective_date between val.effective_start_date AND val.effective_end_date
1270: AND p_effective_date between inputs.effective_start_date AND inputs.effective_end_date;
1271: --
1272: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;
1273: BEGIN
1274:
1275: OPEN c_entry_value;
1276: FETCH c_entry_value INTO l_screen_entry_value;

Line 1304: FROM pay_element_entry_values_f val

1300: IS
1301: CURSOR c_entry_value
1302: IS
1303: SELECT val.screen_entry_value
1304: FROM pay_element_entry_values_f val
1305: ,pay_input_values_f inputs
1306: WHERE val.input_value_id = inputs.input_value_id
1307: AND val.element_entry_id = p_element_entry_id
1308: AND inputs.name = p_input_name

Line 1311: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;

1307: AND val.element_entry_id = p_element_entry_id
1308: AND inputs.name = p_input_name
1309: AND inputs.legislation_code = 'IN';
1310: --
1311: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;
1312: BEGIN
1313: set_location(g_debug, 'Entered '|| g_package||'.get_ee_value',1);
1314: OPEN c_entry_value;
1315: FETCH c_entry_value INTO l_screen_entry_value;