APPS.PAY_US_ACTION_ARCH dependencies on PAY_HOURS_BY_RATE_V

Line 50: from pay_hours_by_rate_v.

46: Also, changed sql statement to
47: use base table instead secure
48: views.
49: 13-APR-2006 ahanda 115.106 Changed HBR code to use amount
50: from pay_hours_by_rate_v.
51: 24-MAR-2006 ahanda 115.105 4924263 Changed archive code to not check
52: if tax exists in a JD for
53: Bal Adj action types.
54: 27-FEB-2006 ahanda 115.104 5058507 Changed HBR code to store the

Line 93: by pay_hours_by_rate view.

89: 06-OCT-2004 ahanda 115.92 3940380 Added parameter p_xfr_action_id
90: to get_last_xfr_info
91: 06-AUG-2004 ahanda 115.91 3814488 Added populate_emp_hours_by_rate
92: to archive all elements returned
93: by pay_hours_by_rate view.
94: 05-AUG-2004 ahanda 115.90 3814488 Added logic for Hours By Rate
95: 20-JUL-2004 ahanda 115.89 3780771 Changed order by in the action
96: creation code
97: 23-JUN-2004 ahanda 115.88 3711280 Changed the logic for NR/R

Line 1553: from pay_hours_by_rate_v hours

1549: hours.rate,
1550: nvl(hours.multiple,1),
1551: hours.hours,
1552: hours.amount
1553: from pay_hours_by_rate_v hours
1554: where hours.assignment_action_id = cp_run_action_id
1555: and legislation_code = 'US'
1556: and hours.element_type_id >= 0 -- Bug 3370112
1557: order by hours.processing_priority,hours.element_type_id;