APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_DEPOSIT_PROCESSES

Line 200: ,hxc_deposit_processes dp

196: bbit.bld_blk_info_type
197: from hxc_mapping_components mc
198: ,hxc_mapping_comp_usages mcu
199: ,hxc_mappings m
200: ,hxc_deposit_processes dp
201: ,hxc_bld_blk_info_types bbit
202: ,hxc_bld_blk_info_type_usages bbui
203: where dp.mapping_id = m.mapping_id
204: and dp.deposit_process_id = p_deposit_process_id

Line 1676: ,hxc_deposit_processes dp

1672: select mc.segment, mc.field_name, bbui.building_block_category
1673: from hxc_mapping_components mc
1674: ,hxc_mapping_comp_usages mcu
1675: ,hxc_mappings m
1676: ,hxc_deposit_processes dp
1677: ,hxc_bld_blk_info_types bbit
1678: ,hxc_bld_blk_info_type_usages bbui
1679: where dp.mapping_id = m.mapping_id
1680: and dp.deposit_process_id = p_deposit_process_id --AI3

Line 2328: ,hxc_deposit_processes dp

2324: select mc.segment, mc.field_name,bbit.bld_blk_info_type
2325: from hxc_mapping_components mc
2326: ,hxc_mapping_comp_usages mcu
2327: ,hxc_mappings m
2328: ,hxc_deposit_processes dp
2329: ,hxc_bld_blk_info_types bbit
2330: where dp.mapping_id = m.mapping_id
2331: and dp.deposit_process_id = p_deposit_process_id
2332: and m.mapping_id = mcu.mapping_id

Line 4036: , hxc_deposit_processes dp

4032:
4033: SELECT dp.deposit_process_id, dp.time_source_id, ts.name
4034: INTO l_deposit_process_id, l_time_source_id, l_time_source_name
4035: FROM hxc_time_sources ts
4036: , hxc_deposit_processes dp
4037: WHERE dp.name = p_deposit_process -- GPM v115.42
4038: AND ts.time_source_id = dp.time_source_id;
4039:
4040: -- Order the time building blocks