APPS.BIX_ALERT dependencies on BISBV_TARGET_LEVELS

Line 180: FROM bisbv_target_levels

176: l_organization_id := -1;
177: -- Get the workflow process
178: SELECT workflow_item_type, workflow_process_short_name
179: INTO l_workflow_item_type, l_workflow_process
180: FROM bisbv_target_levels
181: WHERE target_level_short_name = p_target_level_short_name;
182:
183: -- Get the KPIs users have selected to monitor on their homepage
184: BIS_ACTUAL_PUB.Retrieve_User_Selections

Line 461: FROM bisbv_target_levels

457: l_organization_id := -1;
458: -- Get the workflow process
459: SELECT workflow_item_type, workflow_process_short_name
460: INTO l_workflow_item_type, l_workflow_process
461: FROM bisbv_target_levels
462: WHERE target_level_short_name = p_target_level_short_name;
463:
464: -- Get the KPIs users have selected to monitor on their homepage
465: BIS_ACTUAL_PUB.Retrieve_User_Selections

Line 716: FROM bisbv_target_levels

712: l_organization_id := -1;
713: -- Get the workflow process
714: SELECT workflow_item_type, workflow_process_short_name
715: INTO l_workflow_item_type, l_workflow_process
716: FROM bisbv_target_levels
717: WHERE target_level_short_name = p_target_level_short_name;
718:
719: -- Get the KPIs users have selected to monitor on their homepage
720: BIS_ACTUAL_PUB.Retrieve_User_Selections

Line 1024: FROM bisbv_target_levels

1020: l_organization_id := -1;
1021: -- Get the workflow process
1022: SELECT workflow_item_type, workflow_process_short_name
1023: INTO l_workflow_item_type, l_workflow_process
1024: FROM bisbv_target_levels
1025: WHERE target_level_short_name = p_target_level_short_name;
1026: -- Get the KPIs users have selected to monitor on their homepage
1027: BIS_ACTUAL_PUB.Retrieve_User_Selections
1028: ( p_api_version => 1.0

Line 1329: FROM bisbv_target_levels

1325: l_organization_id := -1;
1326: -- Get the workflow process
1327: SELECT workflow_item_type, workflow_process_short_name
1328: INTO l_workflow_item_type, l_workflow_process
1329: FROM bisbv_target_levels
1330: WHERE target_level_short_name = p_target_level_short_name;
1331:
1332: -- Get the KPIs users have selected to monitor on their homepage
1333: BIS_ACTUAL_PUB.Retrieve_User_Selections

Line 1588: FROM bisbv_target_levels

1584: l_organization_id := -1;
1585: -- Get the workflow process
1586: SELECT workflow_item_type, workflow_process_short_name
1587: INTO l_workflow_item_type, l_workflow_process
1588: FROM bisbv_target_levels
1589: WHERE target_level_short_name = p_target_level_short_name;
1590:
1591: -- Get the KPIs users have selected to monitor on their homepage
1592: BIS_ACTUAL_PUB.Retrieve_User_Selections

Line 1852: FROM bisbv_target_levels

1848: l_organization_id := -1;
1849: -- Get the workflow process
1850: SELECT workflow_item_type, workflow_process_short_name
1851: INTO l_workflow_item_type, l_workflow_process
1852: FROM bisbv_target_levels
1853: WHERE target_level_short_name = p_target_level_short_name;
1854:
1855: -- Get the KPIs users have selected to monitor on their homepage
1856: BIS_ACTUAL_PUB.Retrieve_User_Selections

Line 2114: FROM bisbv_target_levels

2110: l_organization_id := -1;
2111: -- Get the workflow process
2112: SELECT workflow_item_type, workflow_process_short_name
2113: INTO l_workflow_item_type, l_workflow_process
2114: FROM bisbv_target_levels
2115: WHERE target_level_short_name = p_target_level_short_name;
2116:
2117: -- Get the KPIs users have selected to monitor on their homepage
2118: BIS_ACTUAL_PUB.Retrieve_User_Selections