DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 2319: pay_element_entry_values_f peevf

2315: CLOSE c_cur_home_state_jd;
2316: ELSE
2317: select nvl((select peevf.screen_entry_value jurisdiction_code
2318: from pay_input_values_f pivf,
2319: pay_element_entry_values_f peevf
2320: where pivf.element_type_id = ln_element_type_id
2321: AND pivf.NAME = 'Jurisdiction'
2322: AND peevf.element_entry_id = ln_element_entry_id
2323: AND pivf.input_value_id = peevf.input_value_id),(SELECT distinct pus.state_code

Line 4512: pay_element_entry_values_f peevf

4508: ELSE
4509:
4510: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
4511: from pay_input_values_f pivf,
4512: pay_element_entry_values_f peevf
4513: where pivf.element_type_id = p_element_type_id
4514: AND pivf.NAME = 'Jurisdiction'
4515: AND peevf.element_entry_id = ln_element_entry_id
4516: AND pivf.input_value_id = peevf.input_value_id),(SELECT distinct pus.state_code

Line 5047: pay_element_entry_values_f peevf

5043: ELSE
5044:
5045: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
5046: from pay_input_values_f pivf,
5047: pay_element_entry_values_f peevf
5048: where pivf.element_type_id = p_element_type_id
5049: AND pivf.NAME = 'Jurisdiction'
5050: AND peevf.element_entry_id = ln_element_entry_id
5051: AND pivf.input_value_id = peevf.input_value_id),(SELECT distinct pus.state_code