DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on HR_LOCATIONS_ALL_TL

Line 990: INDEX(loct HR_LOCATIONS_ALL_TL_PK)

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)
994: INDEX(pcak PAY_COST_ALLOCATION_KEYFLE_PK)

Line 1096: hr_locations_all_tl loct, --FORMS60

1092: per_assignments_f asm,
1093: pay_element_types_f elt,
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(+)

Line 1228: hr_locations_all_tl loct, --FORMS60

1224: pay_element_types_f elt,
1225: pay_cost_allocation_keyflex pcak,
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(+)

Line 2659: hr_locations_all_tl loct, --FORMS60

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(+)
2663: AND hrw.location_id = loc.location_id(+)

Line 3157: hr_locations_all_tl loct, --FORMS60

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(+)
3161: AND hrw.location_id = loc.location_id(+)