APPS.HXT_RETRO_MIX dependencies on HXT_DET_HOURS_WORKED_X

Line 845: hxt_det_hours_worked_x hrw,

841: hrw.city_name,
842: hrw.zip_code
843: FROM hxt_timecards_x tim,
844: per_time_periods ptp,
845: hxt_det_hours_worked_x hrw,
846: hr_lookups hcl, --GLOBAL
847: per_assignments_f asm,
848: pay_element_types_f elt,
849: hxt_pay_element_types_f_ddf_v eltv, --SIR65

Line 977: hxt_det_hours_worked_x hrw,

973: hrw.city_name,
974: hrw.zip_code
975: FROM hxt_timecards_x tim,
976: per_time_periods ptp,
977: hxt_det_hours_worked_x hrw,
978: hr_lookups hcl, --GLOBAL
979: per_assignments_f asm,
980: pay_element_types_f elt,
981: pay_cost_allocation_keyflex pcak,

Line 1871: FROM hxt_det_hours_worked_x retro

1867: AND hrw.pay_status = 'C'
1868: AND hrw.amount IS NULL
1869: AND hrw.parent_id > 0
1870: AND EXISTS ( SELECT 'X'
1871: FROM hxt_det_hours_worked_x retro
1872: WHERE hrw.parent_id = retro.parent_id
1873: AND retro.pay_status = 'R'
1874: AND hrw.hours = retro.hours
1875: AND hrw.amount IS NULL

Line 1950: FROM hxt_det_hours_worked_x retro

1946: AND hrw.pay_status = 'C'
1947: AND hrw.amount IS NULL
1948: AND hrw.parent_id > 0
1949: AND EXISTS ( SELECT 'X'
1950: FROM hxt_det_hours_worked_x retro
1951: WHERE hrw.parent_id = retro.parent_id
1952: AND retro.pay_status = 'R'
1953: AND hrw.hours <> retro.hours
1954: AND hrw.amount IS NULL

Line 2033: FROM hxt_det_hours_worked_x retro

2029: AND hrw.pay_status = 'C'
2030: AND hrw.amount IS NOT NULL
2031: AND hrw.parent_id > 0
2032: AND EXISTS ( SELECT 'X'
2033: FROM hxt_det_hours_worked_x retro
2034: WHERE hrw.parent_id = retro.parent_id
2035: AND retro.pay_status = 'R'
2036: AND hrw.amount = retro.amount
2037: AND hrw.amount IS NOT NULL

Line 2113: FROM hxt_det_hours_worked_x retro

2109: AND hrw.pay_status = 'C'
2110: AND hrw.amount IS NOT NULL
2111: AND hrw.parent_id > 0
2112: AND EXISTS ( SELECT 'X'
2113: FROM hxt_det_hours_worked_x retro
2114: WHERE hrw.parent_id = retro.parent_id
2115: AND retro.pay_status = 'R'
2116: AND hrw.amount <> retro.amount
2117: AND hrw.amount IS NOT NULL

Line 2190: FROM hxt_det_hours_worked_x hrw

2186: UPDATE hxt_det_hours_worked_f
2187: SET pay_status = 'C',
2188: last_update_date = SYSDATE
2189: WHERE ROWID IN (SELECT hrw.ROWID
2190: FROM hxt_det_hours_worked_x hrw
2191: WHERE hrw.parent_id > 0
2192: AND hrw.pay_status = 'R'
2193: AND hrw.tim_id = p_tim_id);
2194: END mark_retro_rows_complete;