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: FROM pay_input_values_f piv

234: , TYPE.value_set_id
235: , nvl (b.default_value, TYPE.default_value) hot_default_value
236: FROM (
237: SELECT *
238: FROM pay_input_values_f piv
239: , pay_element_links_f pil
240: WHERE pil.element_type_id = piv.element_type_id
241: AND pil.element_link_id = p_element_link_id
242: and piv.effective_start_date =

Line 787: FROM pay_input_values_f piv

783: , TYPE.value_set_id
784: , nvl (b.default_value, TYPE.default_value) hot_default_value
785: FROM (
786: SELECT *
787: FROM pay_input_values_f piv
788: , pay_element_links_f pil
789: WHERE pil.element_type_id = piv.element_type_id
790: AND pil.element_link_id = p_element_link_id
791: and piv.effective_start_date =