DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 2797: pay_element_entry_values_f peevf

2793: CLOSE c_cur_home_state_jd;
2794: ELSE
2795: select nvl((select peevf.screen_entry_value jurisdiction_code
2796: from pay_input_values_f pivf,
2797: pay_element_entry_values_f peevf
2798: where pivf.element_type_id = ln_element_type_id
2799: AND pivf.NAME = 'Jurisdiction'
2800: AND peevf.element_entry_id = ln_element_entry_id
2801: AND pivf.input_value_id = peevf.input_value_id

Line 5113: pay_element_entry_values_f peevf

5109: ELSE
5110:
5111: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
5112: from pay_input_values_f pivf,
5113: pay_element_entry_values_f peevf
5114: where pivf.element_type_id = p_element_type_id
5115: AND pivf.NAME = 'Jurisdiction'
5116: AND peevf.element_entry_id = ln_element_entry_id
5117: AND pivf.input_value_id = peevf.input_value_id

Line 5668: pay_element_entry_values_f peevf

5664: ELSE
5665:
5666: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
5667: from pay_input_values_f pivf,
5668: pay_element_entry_values_f peevf
5669: where pivf.element_type_id = p_element_type_id
5670: AND pivf.NAME = 'Jurisdiction'
5671: AND peevf.element_entry_id = ln_element_entry_id
5672: AND pivf.input_value_id = peevf.input_value_id

Line 6280: pay_element_entry_values_f peevf

6276: ELSE
6277:
6278: SELECT nvl((select peevf.screen_entry_value jurisdiction_code
6279: from pay_input_values_f pivf,
6280: pay_element_entry_values_f peevf
6281: where pivf.element_type_id = p_element_type_id
6282: AND pivf.NAME = 'Jurisdiction'
6283: AND peevf.element_entry_id = ln_element_entry_id
6284: AND pivf.input_value_id = peevf.input_value_id