APPS.PSP_GENERAL dependencies on HRUSERDT

Line 436: SELECT SUM(DECODE(hruserdt.get_table_value(l_business_group_id, l_ws_table_name, l_work_schedule,

432: l_no_of_days_in_chunk NUMBER;
433:
434: CURSOR business_days_ws_cur (p_low_date IN DATE,
435: p_high_date IN DATE) IS
436: SELECT SUM(DECODE(hruserdt.get_table_value(l_business_group_id, l_ws_table_name, l_work_schedule,
437: TO_CHAR(p_low_date+ (ROWNUM-1), 'DY', 'nls_date_language=english'), p_low_date+ (ROWNUM-1)), 0, 0, 1))
438: FROM DUAL
439: CONNECT BY 1=1
440: AND ROWNUM <= (p_high_date + 1) - p_low_date;