APPS.PAY_PAYWIEEH_PKG dependencies on PAY_INPUT_VALUES_F

Line 84: -- pay_input_values_f as a driving table and prevented usage of index

80: p_screen_entry_value14 in out varchar2,
81: p_screen_entry_value15 in out varchar2) is
82: --
83: -- Bug 510150. Changed cursor's from clause to prevent it from using
84: -- pay_input_values_f as a driving table and prevented usage of index
85: -- PAY_LINK_INPUT_VALUES_F_N2 iby adding 0 to the link.input_value_id
86: -- column, to improve performance.26-Jun-1997.mlisieck.
87:
88: cursor SET_OF_ENTRY_VALUES is

Line 101: from pay_input_values_f_tl TYPE_TL,

97: 'N', entry.screen_entry_value,
98: 'Y', nvl (entry.screen_entry_value,
99: nvl (link.default_value,
100: type.default_value))))) SCREEN_ENTRY_VALUE
101: from pay_input_values_f_tl TYPE_TL,
102: pay_input_values_f TYPE,
103: pay_element_entry_values_f ENTRY,
104: pay_link_input_values_f LINK
105: where link.element_link_id = p_element_link_id

Line 102: pay_input_values_f TYPE,

98: 'Y', nvl (entry.screen_entry_value,
99: nvl (link.default_value,
100: type.default_value))))) SCREEN_ENTRY_VALUE
101: from pay_input_values_f_tl TYPE_TL,
102: pay_input_values_f TYPE,
103: pay_element_entry_values_f ENTRY,
104: pay_link_input_values_f LINK
105: where link.element_link_id = p_element_link_id
106: and entry.element_entry_id = p_element_entry_id