DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on DUAL

Line 1791: FROM dual

1787: l_dummy VARCHAR2(1);
1788:
1789: CURSOR csr_chk_bld_blks_not_empty IS
1790: SELECT 'x'
1791: FROM dual
1792: WHERE EXISTS ( select 'y'
1793: from hxc_tmp_blks );
1794:
1795: t_bb_id tab_bb_id;

Line 4412: from dual;

4408: ' FROM ' ||
4409: l_valueset_r.table_info.table_name || ' ' ||
4410: l_valueset_r.table_info.where_clause
4411: into l_sql_text
4412: from dual;
4413:
4414: IF ( g_debug ) THEN
4415: hr_utility.set_location(l_proc, 30);
4416: END IF;

Line 4932: --individually according to precision and rounding rule

4928:
4929:
4930: --Similar to above
4931: --needed because we have to process each detail block
4932: --individually according to precision and rounding rule
4933:
4934: FUNCTION category_timecard_hrs_ind (
4935: p_tbb_id NUMBER
4936: , p_tbb_ovn NUMBER