DBA Data[Home] [Help]

APPS.BEN_COBRA_REQUIREMENTS dependencies on PAY_RUN_RESULT_VALUES

Line 3923: FROM pay_run_result_values a

3919: ,c_effective_date date
3920: ,c_strt_dt date
3921: ,c_end_dt date) is
3922: SELECT NVL(sum(a.result_value),0) result_value
3923: FROM pay_run_result_values a
3924: ,pay_element_types_f b
3925: ,pay_assignment_actions d
3926: ,pay_payroll_actions e
3927: ,pay_run_results h

Line 4500: FROM pay_run_result_values a

4496: ,c_effective_date date
4497: ,c_strt_dt date
4498: ,c_end_dt date) is
4499: SELECT NVL(sum(a.result_value),0) result_value
4500: FROM pay_run_result_values a
4501: ,pay_element_types_f b
4502: ,pay_assignment_actions d
4503: ,pay_payroll_actions e
4504: ,pay_run_results h

Line 4535: FROM pay_run_result_values a

4531: ,c_strt_dt date
4532: ,c_end_dt date) is
4533: SELECT NVL(sum(a.result_value),0) result_value
4534: ,LAST_DAY(e.date_earned) month_end_dt
4535: FROM pay_run_result_values a
4536: ,pay_element_types_f b
4537: ,pay_assignment_actions d
4538: ,pay_payroll_actions e
4539: ,pay_run_results h

Line 4573: FROM pay_run_result_values a

4569: ,c_rt_strt_dt date
4570: ,c_rt_end_dt date) is
4571: SELECT NVL(sum(a.result_value),0) result_value
4572: ,LAST_DAY(e.date_earned) month_end_dt
4573: FROM pay_run_result_values a
4574: ,pay_element_types_f b
4575: ,pay_assignment_actions d
4576: ,pay_payroll_actions e
4577: ,pay_run_results h