APPS.PAY_FR_DUCS dependencies on PAY_ELEMENT_TYPES_F

Line 698: SELECT /*+ ORDERED USE_NL(et) INDEX(et PAY_ELEMENT_TYPES_F_PK) */

694: , retro_adjustment_type
695: , sum(rate) rate
696: , sum(pv) pv
697: FROM (
698: SELECT /*+ ORDERED USE_NL(et) INDEX(et PAY_ELEMENT_TYPES_F_PK) */
699: rr.run_result_id
700: , nvl(epd.source_asg_action_id,rr.assignment_action_id) source_asg_action_id
701: , epd.process_path
702: , epd.adjustment_type retro_adjustment_type

Line 719: pay_element_types_f et,

715: g_french_pay_value, decode(ec.classification_name,'Rebates',-1,1) *
716: fnd_number.canonical_to_number(rrv.result_value))),0) pv
717: FROM pay_action_interlocks ail,
718: pay_run_results rr,
719: pay_element_types_f et,
720: pay_element_classifications ec,
721: pay_input_values_f iv,
722: pay_run_result_values rrv,
723: pay_entry_process_details epd