APPS.HXC_ELP_UTILS dependencies on DUAL

Line 121: FROM sys.DUAL

117:
118: CURSOR tm_rec_transfer(p_tbb_id NUMBER, p_tbb_ovn NUMBER, p_time_rec_id NUMBER)
119: IS
120: SELECT 'Y' status
121: FROM sys.DUAL
122: WHERE EXISTS ( SELECT htd.time_building_block_id, htd.time_building_block_ovn
123: FROM hxc_transaction_details htd,
124: hxc_transactions ht,
125: hxc_retrieval_processes hrp

Line 626: -- Now check for individual Time Recipients

622: cached_app_set.NEXT (l_index_tmp_app);
623: END LOOP; -- l_index_tmp_app IS NOT NULL
624:
625:
626: -- Now check for individual Time Recipients
627:
628: l_index_tmp_app := NULL;
629: l_index_tmp_app := temp_app_set.FIRST;
630:

Line 951: -- Now check for individual Time Recipients

947:
948: l_index_tmp_app := cached_app_set.NEXT (l_index_tmp_app);
949: END LOOP; -- l_index_tmp_app IS NOT NULL
950:
951: -- Now check for individual Time Recipients
952:
953: l_index_tmp_app := NULL;
954: l_index_tmp_app := temp_app_set_drops.FIRST;
955:

Line 1478: -- Now check for individual Time Recipients

1474: END LOOP; -- l_index_tmp_app IS NOT NULL
1475:
1476:
1477:
1478: -- Now check for individual Time Recipients
1479:
1480:
1481: l_index_tmp_app := NULL;
1482: l_index_tmp_app := temp_app_set.FIRST;

Line 1651: -- Now check for individual Time Recipients

1647: l_index_tmp_app := cached_app_set.NEXT (l_index_tmp_app);
1648: END LOOP; -- l_index_tmp_app IS NOT NULL
1649:
1650:
1651: -- Now check for individual Time Recipients
1652:
1653:
1654: l_index_tmp_app := NULL;
1655: l_index_tmp_app := temp_app_set.FIRST;