APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_BLD_BLK_INFO_TYPES

Line 401: FROM hxc_bld_blk_info_types

397: END IF;
398:
399: SELECT bld_blk_info_type_id
400: INTO g_dummy_bbit
401: FROM hxc_bld_blk_info_types
402: WHERE bld_blk_info_type = 'Dummy Element Context';
403:
404: SELECT bld_blk_info_type_id
405: INTO g_alias_bbit

Line 406: FROM hxc_bld_blk_info_types

402: WHERE bld_blk_info_type = 'Dummy Element Context';
403:
404: SELECT bld_blk_info_type_id
405: INTO g_alias_bbit
406: FROM hxc_bld_blk_info_types
407: WHERE bld_blk_info_type = 'ALTERNATE NAME IDENTIFIERS';
408:
409: -- Bug 8911152
410: -- Added this query to pull up layout attribute's bbit.

Line 413: FROM hxc_bld_blk_info_types

409: -- Bug 8911152
410: -- Added this query to pull up layout attribute's bbit.
411: SELECT bld_blk_info_type_id
412: INTO g_layout_bbit
413: FROM hxc_bld_blk_info_types
414: WHERE bld_blk_info_type = 'LAYOUT';
415:
416:
417: END gen_alt_ids;

Line 4458: FROM hxc_bld_blk_info_types

4454:
4455: BEGIN
4456: SELECT bld_blk_info_type_id
4457: INTO g_bld_blk_info
4458: FROM hxc_bld_blk_info_types
4459: WHERE bld_blk_info_type = 'Dummy Element Context';
4460:
4461: SELECT retrieval_process_id
4462: INTO g_bee_retrieval