APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1278: FROM pay_element_entry_values_f val

1274: IS
1275: CURSOR c_entry_value
1276: IS
1277: SELECT val.screen_entry_value
1278: FROM pay_element_entry_values_f val
1279: ,pay_input_values_f inputs
1280: WHERE val.input_value_id = inputs.input_value_id
1281: AND val.element_entry_id = p_element_entry_id
1282: AND inputs.name = p_input_name

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

1283: AND inputs.legislation_code = 'IN'
1284: AND p_effective_date between val.effective_start_date AND val.effective_end_date
1285: AND p_effective_date between inputs.effective_start_date AND inputs.effective_end_date;
1286: --
1287: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;
1288: BEGIN
1289:
1290: OPEN c_entry_value;
1291: FETCH c_entry_value INTO l_screen_entry_value;

Line 1319: FROM pay_element_entry_values_f val

1315: IS
1316: CURSOR c_entry_value
1317: IS
1318: SELECT val.screen_entry_value
1319: FROM pay_element_entry_values_f val
1320: ,pay_input_values_f inputs
1321: WHERE val.input_value_id = inputs.input_value_id
1322: AND val.element_entry_id = p_element_entry_id
1323: AND inputs.name = p_input_name

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

1322: AND val.element_entry_id = p_element_entry_id
1323: AND inputs.name = p_input_name
1324: AND inputs.legislation_code = 'IN';
1325: --
1326: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;
1327: BEGIN
1328: set_location(g_debug, 'Entered '|| g_package||'.get_ee_value',1);
1329: OPEN c_entry_value;
1330: FETCH c_entry_value INTO l_screen_entry_value;