APPS.PAY_US_ACTION_ARCH dependencies on PAY_HOURS_BY_RATE_V

Line 134: from pay_hours_by_rate_v.

130: Also, changed sql statement to
131: use base table instead secure
132: views.
133: 13-APR-2006 ahanda 115.106 Changed HBR code to use amount
134: from pay_hours_by_rate_v.
135: 24-MAR-2006 ahanda 115.105 4924263 Changed archive code to not check
136: if tax exists in a JD for
137: Bal Adj action types.
138: 27-FEB-2006 ahanda 115.104 5058507 Changed HBR code to store the

Line 177: by pay_hours_by_rate view.

173: 06-OCT-2004 ahanda 115.92 3940380 Added parameter p_xfr_action_id
174: to get_last_xfr_info
175: 06-AUG-2004 ahanda 115.91 3814488 Added populate_emp_hours_by_rate
176: to archive all elements returned
177: by pay_hours_by_rate view.
178: 05-AUG-2004 ahanda 115.90 3814488 Added logic for Hours By Rate
179: 20-JUL-2004 ahanda 115.89 3780771 Changed order by in the action
180: creation code
181: 23-JUN-2004 ahanda 115.88 3711280 Changed the logic for NR/R

Line 1876: from pay_hours_by_rate_v hours

1872: hours.rate,
1873: nvl(hours.multiple,1),
1874: hours.hours,
1875: hours.amount
1876: from pay_hours_by_rate_v hours
1877: where hours.assignment_action_id = cp_run_action_id
1878: and legislation_code = 'US'
1879: and hours.element_type_id >= 0 -- Bug 3370112
1880: order by hours.processing_priority,hours.element_type_id;