DBA Data[Home] [Help]

APPS.HXC_HAC_BUS dependencies on HXC_TIME_RECIPIENTS

Line 1192: -- in the hxc_time_recipients table if the parent_comp_id and

1188: -- This procedure is used to enforce the business rule that if the
1189: -- parent_comp_id and parent_comp_ovn are not null then the
1190: -- time recipient must be -1
1191: -- The time_category_id field must belong to the list of time recipients
1192: -- in the hxc_time_recipients table if the parent_comp_id and
1193: -- parent_comp_ovn are not null
1194: --
1195: -- Prerequisites:
1196: -- None.

Line 1229: FROM hxc_time_recipients htr

1225:
1226: CURSOR c_time_recipient_exists
1227: IS
1228: SELECT 'Y'
1229: FROM hxc_time_recipients htr
1230: WHERE htr.time_recipient_id = p_time_recipient_id;
1231:
1232: l_dummy VARCHAR2(1);
1233: --