APPS.HXC_HAC_BUS dependencies on HXC_TIME_CATEGORIES

Line 1018: -- time categories in hxc_time_categories table.

1014: -- Description:
1015: -- This procedure is used to enforce the business rule that if the
1016: -- parent_comp_id and parent_comp_ovn are not null then the
1017: -- time category must be either 0 or belong to the list of
1018: -- time categories in hxc_time_categories table.
1019: -- The time_category_id field must be null if the parent_comp_id and
1020: -- parent_comp_ovn are null.
1021: --
1022: -- Prerequisites:

Line 1056: FROM hxc_time_categories htc

1052:
1053: CURSOR c_time_category_exists
1054: IS
1055: SELECT 'Y'
1056: FROM hxc_time_categories htc
1057: WHERE htc.time_category_id = p_time_category_id;
1058:
1059: l_dummy VARCHAR2(1);
1060: --