APPS.HXT_RETRO_MIX dependencies on FND_FLEX_VALUES

Line 989: INDEX(ffvr FND_FLEX_VALUES_U1)

985: SELECT /*+ LEADING(tim.HXT_TIMECARDS_F)
986: INDEX(tim.HXT_TIMECARDS_F HXT_TIMECARDS_PK)
987: USE_NL(tim.HXT_TIMECARDS_F hrw.HXT_DET_HOURS_WORKED_F)
988: INDEX(hrw.HXT_DET_HOURS_WORKED_F HXT_DET_HOURS_WORKED_F_TIM_FK)
989: INDEX(ffvr FND_FLEX_VALUES_U1)
990: INDEX(loct HR_LOCATIONS_ALL_TL_PK)
991: INDEX(loc.HR_LOCATIONS_ALL HR_LOCATIONS_PK)
992: INDEX(elt PAY_ELEMENT_TYPES_F_PK)
993: INDEX(eltv.HXT_ADD_ELEM_INFO_F HXT_ADD_ELEM_INFO_ON1)

Line 1098: fnd_flex_values ffvr

1094: hxt_pay_element_types_f_ddf_v eltv, --SIR65
1095: pay_cost_allocation_keyflex pcak,
1096: hr_locations_all_tl loct, --FORMS60
1097: hr_locations_no_join loc, --FORMS60
1098: fnd_flex_values ffvr
1099: WHERE hrw.ffv_rate_code_id = ffvr.flex_value_id(+)
1100: AND hrw.location_id = loc.location_id(+)
1101: AND hsw.id = hrw.parent_id
1102: AND loc.location_id = loct.location_id(+)

Line 1230: fnd_flex_values ffvr

1226:
1227:
1228: hr_locations_all_tl loct, --FORMS60
1229: hr_locations_no_join loc, --FORMS60
1230: fnd_flex_values ffvr
1231: WHERE hrw.ffv_rate_code_id = ffvr.flex_value_id(+)
1232: AND hrw.location_id = loc.location_id(+)
1233:
1234: --BEGIN FORMS60

Line 2658: /*TA36fnd_flex_values ffvl, */

2654: pay_element_types_f elt,
2655: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2656: pay_cost_allocation_keyflex pcak,
2657:
2658: /*TA36fnd_flex_values ffvl, */
2659: hr_locations_all_tl loct, --FORMS60
2660: hr_locations_no_join loc, --FORMS60
2661: fnd_flex_values ffvr
2662: WHERE hrw.ffv_rate_code_id = ffvr.flex_value_id(+)

Line 2661: fnd_flex_values ffvr

2657:
2658: /*TA36fnd_flex_values ffvl, */
2659: hr_locations_all_tl loct, --FORMS60
2660: hr_locations_no_join loc, --FORMS60
2661: fnd_flex_values ffvr
2662: WHERE hrw.ffv_rate_code_id = ffvr.flex_value_id(+)
2663: AND hrw.location_id = loc.location_id(+)
2664:
2665: --BEGIN FORMS60

Line 3156: /*TA36fnd_flex_values ffvl, */

3152: per_assignments_f asm,
3153: pay_element_types_f elt,
3154: pay_cost_allocation_keyflex pcak,
3155:
3156: /*TA36fnd_flex_values ffvl, */
3157: hr_locations_all_tl loct, --FORMS60
3158: hr_locations_no_join loc, --FORMS60
3159: fnd_flex_values ffvr
3160: WHERE hrw.ffv_rate_code_id = ffvr.flex_value_id(+)

Line 3159: fnd_flex_values ffvr

3155:
3156: /*TA36fnd_flex_values ffvl, */
3157: hr_locations_all_tl loct, --FORMS60
3158: hr_locations_no_join loc, --FORMS60
3159: fnd_flex_values ffvr
3160: WHERE hrw.ffv_rate_code_id = ffvr.flex_value_id(+)
3161: AND hrw.location_id = loc.location_id(+)
3162:
3163: --BEGIN FORMS60