APPS.BIM_DBI_BGT_MGMT_PVT dependencies on BIM_I_SOURCE_CODES

Line 1078: from bim_i_source_codes

1074: /* cursor to get type of object passed from the page ******/
1075: cursor get_obj_type
1076: is
1077: select object_type
1078: from bim_i_source_codes
1079: where source_code_id=replace(l_campaign_id,'''');
1080: /*********************************************************/
1081: l_object_type varchar2(30);
1082: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1289: l_from := l_from ||',ams_act_access_denorm ac,bim_i_source_codes src ';

1285: AND ac.resource_id = :l_resource_id ';
1286: /************************************************/
1287: ELSE
1288:
1289: l_from := l_from ||',ams_act_access_denorm ac,bim_i_source_codes src ';
1290: l_where := l_where ||' AND a.source_code_id=src.source_code_id
1291: AND src.object_id=ac.object_id
1292: AND src.object_type=ac.object_type
1293: AND ac.resource_id = :l_resource_id ';

Line 1387: /* appending table in l_form and joining conditon for the bim_i_source_codes */

1383: ELSE
1384:
1385:
1386: /* source_code_id is passed from the page, object selected from the page to be drill may be program,campaign,event,one off event*****/
1387: /* appending table in l_form and joining conditon for the bim_i_source_codes */
1388: l_where :=l_where ||' AND a.immediate_parent_id = :l_campaign_id ';
1389: -- checking for the object type passed from page
1390:
1391: for i in get_obj_type