DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on DUAL

Line 1770: FROM dual

1766: l_dummy VARCHAR2(1);
1767:
1768: CURSOR csr_chk_bld_blks_not_empty IS
1769: SELECT 'x'
1770: FROM dual
1771: WHERE EXISTS ( select 'y'
1772: from hxc_tmp_blks );
1773:
1774: t_bb_id tab_bb_id;

Line 4295: from dual;

4291: ' FROM ' ||
4292: l_valueset_r.table_info.table_name || ' ' ||
4293: l_valueset_r.table_info.where_clause
4294: into l_sql_text
4295: from dual;
4296:
4297: IF ( g_debug ) THEN
4298: hr_utility.set_location(l_proc, 30);
4299: END IF;

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

4811:
4812:
4813: --Similar to above
4814: --needed because we have to process each detail block
4815: --individually according to precision and rounding rule
4816:
4817: FUNCTION category_timecard_hrs_ind (
4818: p_tbb_id NUMBER
4819: , p_tbb_ovn NUMBER