DBA Data[Home] [Help]

APPS.PAY_PAYWSLEE_PKG dependencies on PAY_INPUT_VALUES_F

Line 27: from pay_input_values_f_tl INPUT_VALUE_TL,

23: cursor set_of_input_values is
24: --
25: select input_value_tl.name
26: --
27: from pay_input_values_f_tl INPUT_VALUE_TL,
28: pay_input_values_f INPUT_VALUE
29: --
30: where input_value.element_type_id = p_element_type_id
31: and input_value_tl.input_value_id = input_value.input_value_id

Line 28: pay_input_values_f INPUT_VALUE

24: --
25: select input_value_tl.name
26: --
27: from pay_input_values_f_tl INPUT_VALUE_TL,
28: pay_input_values_f INPUT_VALUE
29: --
30: where input_value.element_type_id = p_element_type_id
31: and input_value_tl.input_value_id = input_value.input_value_id
32: and userenv('LANG') = input_value_tl.language

Line 149: from pay_input_values_f_tl INPUT_VALUE_TL,

145: cursor set_of_input_values is
146: --
147: select input_value_tl.name
148: --
149: from pay_input_values_f_tl INPUT_VALUE_TL,
150: pay_input_values_f INPUT_VALUE
151: --
152: where input_value.element_type_id = p_element_type_id
153: and input_value_tl.input_value_id = input_value.input_value_id

Line 150: pay_input_values_f INPUT_VALUE

146: --
147: select input_value_tl.name
148: --
149: from pay_input_values_f_tl INPUT_VALUE_TL,
150: pay_input_values_f INPUT_VALUE
151: --
152: where input_value.element_type_id = p_element_type_id
153: and input_value_tl.input_value_id = input_value.input_value_id
154: and userenv('LANG') = input_value_tl.language

Line 238: pay_input_values_f TYPE

234: type.value_set_id,
235: nvl (link.default_value, type.default_value) HOT_DEFAULT_VALUE
236: from pay_element_entry_values_f ENTRY,
237: pay_link_input_values_f LINK,
238: pay_input_values_f TYPE
239: where entry.element_entry_id = p_element_entry_id
240: and link.element_link_id = p_element_link_id
241: and link.input_value_id = entry.input_value_id
242: and type.input_value_id = entry.input_value_id

Line 773: pay_input_values_f TYPE

769: type.value_set_id,
770: nvl (link.default_value, type.default_value) HOT_DEFAULT_VALUE
771: from pay_element_entry_values_f ENTRY,
772: pay_link_input_values_f LINK,
773: pay_input_values_f TYPE
774: where entry.element_entry_id = p_element_entry_id
775: and link.element_link_id = p_element_link_id
776: and link.input_value_id = entry.input_value_id
777: and type.input_value_id = entry.input_value_id