DBA Data[Home] [Help]

APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_HOURS_BY_RATE_V

Line 1771: FROM pay_hours_by_rate_v mul

1767: cp_element_type_id NUMBER,
1768: cp_legislation_code VARCHAR2)
1769: IS
1770: SELECT NVL(mul.multiple,1),mul.rate
1771: FROM pay_hours_by_rate_v mul
1772: WHERE mul.assignment_action_id = cp_run_action_id
1773: AND legislation_code = cp_legislation_code
1774: AND mul.element_type_id >= 0
1775: AND mul.element_type_id = p_element_type_id

Line 2764: FROM pay_hours_by_rate_v hours

2760: hours.rate,
2761: nvl(hours.multiple,1),
2762: hours.hours,
2763: hours.amount
2764: FROM pay_hours_by_rate_v hours
2765: WHERE hours.assignment_action_id = cp_ytd_action_id
2766: AND legislation_code = 'US'
2767: AND hours.element_type_id >= 0
2768: ORDER BY hours.processing_priority,hours.element_type_id;