335: pay_assignment_actions paa,
336: pay_action_interlocks pai,
337: pay_pre_payments ppp,
338: pay_input_values_f piv_pay,
339: pay_run_result_values prrv_att,
340: pay_run_result_values prrv_pay
341: WHERE ppp.value = p_amount
342: and ppp.pre_payment_id = p_ppm_id
343: and ppp.assignment_action_id = pai.locking_action_id
336: pay_action_interlocks pai,
337: pay_pre_payments ppp,
338: pay_input_values_f piv_pay,
339: pay_run_result_values prrv_att,
340: pay_run_result_values prrv_pay
341: WHERE ppp.value = p_amount
342: and ppp.pre_payment_id = p_ppm_id
343: and ppp.assignment_action_id = pai.locking_action_id
344: and pai.locked_action_id = paa.assignment_action_id
395: pay_assignment_actions paa,
396: pay_action_interlocks pai,
397: pay_pre_payments ppp,
398: pay_input_values_f piv_pay,
399: pay_run_result_values prrv_att,
400: pay_run_result_values prrv_pay,
401: pay_element_types_f pet,
402: pay_element_types_f pet_calc,
403: pay_element_classifications pec
396: pay_action_interlocks pai,
397: pay_pre_payments ppp,
398: pay_input_values_f piv_pay,
399: pay_run_result_values prrv_att,
400: pay_run_result_values prrv_pay,
401: pay_element_types_f pet,
402: pay_element_types_f pet_calc,
403: pay_element_classifications pec
404: WHERE ppp.value = p_amount