DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on PAY_INPUT_VALUES_F

Line 1264: ,pay_input_values_f inputs

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
1268: AND inputs.legislation_code = 'IN'

Line 1305: ,pay_input_values_f inputs

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
1309: AND inputs.legislation_code = 'IN';

Line 1566: FROM pay_input_values_f

1562: IS
1563: CURSOR c_input_value_id
1564: IS
1565: SELECT input_value_id
1566: FROM pay_input_values_f
1567: WHERE element_type_id = p_element_id
1568: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1569: AND NAME = p_input_value;
1570: