DBA Data[Home] [Help]

APPS.HRI_BPL_UTILIZATION dependencies on PER_BUSINESS_GROUPS

Line 45: ,per_business_groups bgr

41: UNION ALL
42: SELECT 'Y'
43: FROM
44: ff_formulas_f fff
45: ,per_business_groups bgr
46: WHERE fff.formula_type_id = g_formula_type_id
47: AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
48: AND fff.business_group_id IS NULL
49: AND bgr.business_group_id = p_business_group_id

Line 302: ,per_business_groups bgr

298: FROM
299: per_absence_attendances paa
300: ,per_absence_attendance_types pat
301: ,pay_input_values_f piv
302: ,per_business_groups bgr
303: WHERE paa.absence_attendance_id = p_absence_attendance_id
304: AND paa.business_group_id = bgr.business_group_id
305: AND paa.absence_attendance_type_id = pat.absence_attendance_type_id
306: AND pat.input_value_id = piv.input_value_id (+)