DBA Data[Home] [Help]

APPS.PAY_QPQ_API dependencies on PAY_INPUT_VALUES_F

Line 145: from pay_input_values_f INPVAL

141: processed separately, depending upon the parameter */
142: and (nvl (PI_LOOK_FOR_SEPARATE_CHECK, 'NO') = 'YES'
143: and exists (
144: select 1
145: from pay_input_values_f INPVAL
146: where inpval.element_type_id = element.element_type_id
147: and ((upper (inpval.name) in ( 'SEPARATE CHECK',
148: 'TAX SEPARATELY')
149: and entval.screen_entry_value = 'Y')

Line 159: from pay_input_values_f INPVAL

155: and inpval.effective_end_date)
156: or (nvl (PI_LOOK_FOR_SEPARATE_CHECK, 'NO') <> 'YES'
157: and NOT exists (
158: select 1
159: from pay_input_values_f INPVAL
160: where inpval.element_type_id = element.element_type_id
161: and ((upper (inpval.name) in ( 'SEPARATE CHECK',
162: 'TAX SEPARATELY')
163: and entval.screen_entry_value = 'Y')

Line 247: from pay_input_values_f INPVAL

243: processed separately, depending upon the parameter */
244: and (nvl (PI_LOOK_FOR_SEPARATE_CHECK, 'NO') = 'YES'
245: and exists (
246: select 1
247: from pay_input_values_f INPVAL
248: where inpval.element_type_id = element.element_type_id
249: and ((upper (inpval.name) in ( 'SEPARATE CHECK',
250: 'TAX SEPARATELY')
251: and entval.screen_entry_value = 'Y')

Line 261: from pay_input_values_f INPVAL

257: and inpval.effective_end_date)
258: or (nvl (PI_LOOK_FOR_SEPARATE_CHECK, 'NO') <> 'YES'
259: and NOT exists (
260: select 1
261: from pay_input_values_f INPVAL
262: where inpval.element_type_id = element.element_type_id
263: and ((upper (inpval.name) in ( 'SEPARATE CHECK',
264: 'TAX SEPARATELY')
265: and entval.screen_entry_value = 'Y')