APPS.PAY_NO_SUPPORT_ORDER dependencies on PAY_INPUT_VALUES_F

Line 191: from pay_input_values_f

187:
188: --cursor get the input value id for the input value names above
189: CURSOR csr_element_iv_id (l_ele_type_id NUMBER , l_iv_name VARCHAR2) IS
190: select INPUT_VALUE_ID
191: from pay_input_values_f
192: where ELEMENT_TYPE_ID = l_ele_type_id
193: AND NAME = l_iv_name ;
194:
195:

Line 208: ,pay_input_values_f ipv1

204: ,info.EEI_INFORMATION5 def_bal_id
205:
206: from pay_element_types_f ele
207: ,pay_element_type_extra_info info
208: ,pay_input_values_f ipv1
209: ,pay_input_values_f ipv2
210:
211: where ele.ELEMENT_TYPE_ID = p_ele_type_id
212: -- for pay_element_type_extra_info

Line 209: ,pay_input_values_f ipv2

205:
206: from pay_element_types_f ele
207: ,pay_element_type_extra_info info
208: ,pay_input_values_f ipv1
209: ,pay_input_values_f ipv2
210:
211: where ele.ELEMENT_TYPE_ID = p_ele_type_id
212: -- for pay_element_type_extra_info
213: AND info.ELEMENT_TYPE_ID = ele.ELEMENT_TYPE_ID

Line 250: from pay_input_values_f ipv1

246: ,ipv3.INPUT_VALUE_ID ipv3_id -- Deduction Percentage
247: ,ipv4.INPUT_VALUE_ID ipv4_id -- Reference Number
248: ,ipv5.INPUT_VALUE_ID ipv5_id -- Pay Value
249:
250: from pay_input_values_f ipv1
251: ,pay_input_values_f ipv2
252: ,pay_input_values_f ipv3
253: ,pay_input_values_f ipv4
254: ,pay_input_values_f ipv5

Line 251: ,pay_input_values_f ipv2

247: ,ipv4.INPUT_VALUE_ID ipv4_id -- Reference Number
248: ,ipv5.INPUT_VALUE_ID ipv5_id -- Pay Value
249:
250: from pay_input_values_f ipv1
251: ,pay_input_values_f ipv2
252: ,pay_input_values_f ipv3
253: ,pay_input_values_f ipv4
254: ,pay_input_values_f ipv5
255:

Line 252: ,pay_input_values_f ipv3

248: ,ipv5.INPUT_VALUE_ID ipv5_id -- Pay Value
249:
250: from pay_input_values_f ipv1
251: ,pay_input_values_f ipv2
252: ,pay_input_values_f ipv3
253: ,pay_input_values_f ipv4
254: ,pay_input_values_f ipv5
255:
256: WHERE

Line 253: ,pay_input_values_f ipv4

249:
250: from pay_input_values_f ipv1
251: ,pay_input_values_f ipv2
252: ,pay_input_values_f ipv3
253: ,pay_input_values_f ipv4
254: ,pay_input_values_f ipv5
255:
256: WHERE
257: -- for input value Third Party Payee

Line 254: ,pay_input_values_f ipv5

250: from pay_input_values_f ipv1
251: ,pay_input_values_f ipv2
252: ,pay_input_values_f ipv3
253: ,pay_input_values_f ipv4
254: ,pay_input_values_f ipv5
255:
256: WHERE
257: -- for input value Third Party Payee
258: ipv1.ELEMENT_TYPE_ID = p_ele_type_id

Line 516: ,pay_input_values_f inpv

512: ,pay_payroll_actions ppa3
513: ,per_all_assignments_f asg
514: ,pay_run_results prr
515: ,pay_run_result_values prrv
516: ,pay_input_values_f inpv
517: ,pay_action_interlocks pai
518:
519: WHERE -- initial conditions
520: