APPS.PAY_AC_ACTION_ARCH dependencies on PAY_HOURS_BY_RATE_V

Line 188: pay_hours_by_rate_v

184: 11-JUL-2006 ppanda 115.73 Changed cursor c_prev_ytd_action_elements
185: for fixing R12 performance bug 5042715
186: 13-APR-2006 ahanda 115.72 Changed populate_hours_x_rate
187: to use amount returned by
188: pay_hours_by_rate_v
189: 08-Mar-2006 vpandya 115.71 Changed populate_hours_x_rate
190: procedure to fix retro issue
191: for Canada.
192: 14-OCT-2005 ahanda 115.70 Changed the prev_ytd .. cursors

Line 1196: from pay_hours_by_rate_v mul

1192:
1193: /*12819017-Start*/
1194: cursor c_hbr(cp_run_action_id in number,p_element_type_id in number) is
1195: select nvl(mul.multiple,1),mul.rate
1196: from pay_hours_by_rate_v mul
1197: where mul.assignment_action_id = cp_run_action_id
1198: and legislation_code = 'US'
1199: and mul.element_type_id >= 0 -- Bug 3370112
1200: and mul.element_type_id = p_element_type_id

Line 1604: from pay_hours_by_rate_v hours

1600: hours.multiple,
1601: hours.hours,
1602: hours.amount,
1603: hours.assignment_action_id
1604: from pay_hours_by_rate_v hours
1605: where hours.assignment_action_id = cp_assignment_action_id
1606: and legislation_code in ('US', 'CA') -- Bug 3370112
1607: and hours.element_type_id >= 0 -- Bug 3370112
1608: order by hours.processing_priority,hours.element_type_id;