APPS.BIL_TX_UTIL_RPT_PKG dependencies on AS_STATUSES_B

Line 1116: FROM as_statuses_b asb, as_statuses_tl ast, BIL_TX_PROD_TMP B

1112:
1113:
1114:
1115: OPEN l_status_c FOR 'SELECT ast.meaning
1116: FROM as_statuses_b asb, as_statuses_tl ast, BIL_TX_PROD_TMP B
1117: WHERE asb.status_code = B.ATTR4
1118: AND asb.status_code = ast.status_code
1119: AND ast.language= userenv(''LANG'')
1120: AND asb.enabled_flag = ''Y''

Line 1136: FROM as_statuses_b asb, as_statuses_tl ast

1132: END LOOP;
1133: CLOSE l_status_c;
1134: ELSE
1135: OPEN l_status_c FOR 'SELECT ast.meaning
1136: FROM as_statuses_b asb, as_statuses_tl ast
1137: WHERE asb.status_code = ast.status_code
1138: AND ast.language= userenv(''LANG'')
1139: AND asb.enabled_flag = ''Y''
1140: AND asb.opp_flag = ''Y''

Line 1358: FROM as_statuses_b asb

1354: l_stats_cods VARCHAR2(1000);
1355: l_cnt number := 0;
1356: CURSOR status_cur(l_flgs VARCHAR2) IS
1357: SELECT asb.status_code
1358: FROM as_statuses_b asb
1359: WHERE asb.enabled_flag = 'Y'
1360: AND asb.opp_flag = 'Y'
1361: AND win_loss_indicator||opp_open_status_flag||forecast_rollup_flag LIKE l_flgs;
1362: