DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on PAY_INPUT_VALUES_F

Line 1279: ,pay_input_values_f inputs

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

Line 1320: ,pay_input_values_f inputs

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

Line 1581: FROM pay_input_values_f

1577: IS
1578: CURSOR c_input_value_id
1579: IS
1580: SELECT input_value_id
1581: FROM pay_input_values_f
1582: WHERE element_type_id = p_element_id
1583: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1584: AND NAME = p_input_value;
1585: