11:
12:
13: BEGIN
14:
15: l_resource_id := BIL_TX_UTIL_RPT_PKG.GET_RESOURCE_ID;
16: l_group_id := BIL_TX_UTIL_RPT_PKG.get_sales_group_id;
17: l_exception := NULL;
18: BEGIN
19: SELECT 'Y'
12:
13: BEGIN
14:
15: l_resource_id := BIL_TX_UTIL_RPT_PKG.GET_RESOURCE_ID;
16: l_group_id := BIL_TX_UTIL_RPT_PKG.get_sales_group_id;
17: l_exception := NULL;
18: BEGIN
19: SELECT 'Y'
20: INTO l_manager
46: l_resource_id NUMBER;
47: l_group_id NUMBER;
48:
49: BEGIN
50: l_resource_id := BIL_TX_UTIL_RPT_PKG.GET_RESOURCE_ID;
51: l_group_id := BIL_TX_UTIL_RPT_PKG.get_sales_group_id;
52:
53: BEGIN
54: SELECT 'x'
47: l_group_id NUMBER;
48:
49: BEGIN
50: l_resource_id := BIL_TX_UTIL_RPT_PKG.GET_RESOURCE_ID;
51: l_group_id := BIL_TX_UTIL_RPT_PKG.get_sales_group_id;
52:
53: BEGIN
54: SELECT 'x'
55: INTO l_dummy