DBA Data[Home] [Help]

APPS.BEN_COBRA_REQUIREMENTS dependencies on PAY_RUN_RESULT_VALUES

Line 3564: FROM pay_run_result_values a

3560: ,c_effective_date date
3561: ,c_strt_dt date
3562: ,c_end_dt date) is
3563: SELECT NVL(sum(a.result_value),0) result_value
3564: FROM pay_run_result_values a
3565: ,pay_element_types_f b
3566: ,pay_assignment_actions d
3567: ,pay_payroll_actions e
3568: ,pay_run_results h

Line 4141: FROM pay_run_result_values a

4137: ,c_effective_date date
4138: ,c_strt_dt date
4139: ,c_end_dt date) is
4140: SELECT NVL(sum(a.result_value),0) result_value
4141: FROM pay_run_result_values a
4142: ,pay_element_types_f b
4143: ,pay_assignment_actions d
4144: ,pay_payroll_actions e
4145: ,pay_run_results h

Line 4176: FROM pay_run_result_values a

4172: ,c_strt_dt date
4173: ,c_end_dt date) is
4174: SELECT NVL(sum(a.result_value),0) result_value
4175: ,LAST_DAY(e.date_earned) month_end_dt
4176: FROM pay_run_result_values a
4177: ,pay_element_types_f b
4178: ,pay_assignment_actions d
4179: ,pay_payroll_actions e
4180: ,pay_run_results h

Line 4214: FROM pay_run_result_values a

4210: ,c_rt_strt_dt date
4211: ,c_rt_end_dt date) is
4212: SELECT NVL(sum(a.result_value),0) result_value
4213: ,LAST_DAY(e.date_earned) month_end_dt
4214: FROM pay_run_result_values a
4215: ,pay_element_types_f b
4216: ,pay_assignment_actions d
4217: ,pay_payroll_actions e
4218: ,pay_run_results h