DBA Data[Home] [Help]

APPS.BEN_COBRA_REQUIREMENTS dependencies on PAY_ELEMENT_TYPES_F

Line 3565: ,pay_element_types_f b

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
3569: ,ben_acty_base_rt_f i

Line 4142: ,pay_element_types_f b

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
4146: ,ben_acty_base_rt_f i

Line 4177: ,pay_element_types_f b

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
4181: ,ben_acty_base_rt_f i

Line 4215: ,pay_element_types_f b

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
4219: ,ben_acty_base_rt_f i